Hi ,
I have a situation like this:
| DATE | Code | N. Piece | Amount |
|---|
| 201705 | A | 5 | 50 |
| 201705 | B | 8 | 100 |
| 201705 | C | 6 | 75 |
| 201706 | A | 12 | 80 |
| 201706 | B | 15 | 122 |
| 201706 | C | 10 | 90 |
| 201707 | A | 19 | 101 |
| 201707 | B | 22 | 134 |
| 201707 | C | 21 | 98 |
The Date format is 'YYYYMM' .
Every month has about 130.000 rows and the Measures are cumulative from the previous month. What I need is calculate the Delta between months and I cannot use function like "Before" or "Above".
So I thought to use Set Analysis but when I use Date-Function for filter by the previous month the sistem returns me 0 or in others cases the identical value of the month instead of the previous.
I hope to be exhaustive.
Can someone help me please?
Thank you All.
