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 ne...
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?