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.