Forum Discussion
Transfer unsold quantity
Hi,
I have a table with weekly start dates and order deliveries as illustrated. I want to achieve same as the result column where any quantity unsold in the previous season has to be moved to the new season and a negative entry of the unsold qty to show on the last week of previous season and positive entry to show on the first week of new season. Rest all deliveries should also show. Product is the same in illustration.
I have a table with 2m rows for all the products in the business with over 4000 different products but the change of season scenario affects only selected fast selling products.
3 Replies
could you pls provide some sample data? why we get 1800 at the end of summer 24?
That negative -1800 is what I want to achieve at the end of Summer 24. Basically, the sum of deliveries for summer is 4000 and sold qty is 2200 which means the balance 1800 should be transferred to next season. This transfer qty should show a negative number at the end of previous season and positive number at the start of new season.
could you pls proivde some sample data? The screenshot is the sample data you have?
We can't just import that format to powerbi because the sold out is only in a cell in excel. Do we have a sold out table?
