Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
In QV 11 I have the following challenge: At a certain moment in time we start selling a product, then 2 years later I would like to have an overview what has been sold in the previous 4 months. My start amount in this overview are all my aggregated amounts starting at the beginning up to my current selected periode.
Period 0,1, 2 etc. are year months combinations in my datasetc.
Below you will find an example:
start | aggregated sales per period | aggregated | |
period 0 | 0 | 10 | 10 |
period 1 | 10 | 10 | 20 |
period 2 | 20 | 30 | 50 |
period 3 | 50 | 20 | 70 |
period 4 | 70 | 10 | 80 |
period 5 | 80 | 40 | 120 |
period 6 | 120 | 45 | 165 |
period 7 | 165 | 35 | 200 |
period 8 | 200 | 20 | 220 |
Chart | |||
Period 4 | 70 | 10 | 80 |
Period 5 | 80 | 40 | 120 |
Period 6 | 120 | 45 | 165 |
Period 7 | 165 | 35 | 200 |
Period 8 | 200 | 20 | 220 |
Thanks in advance
Hi all thank you if you were trying to find a solution, but thanks I already solved it.
Hi all thank you if you were trying to find a solution, but thanks I already solved it.