Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Chiara,
this is possible if you remove the where condition in
<< as-of-table>>
Regards
Stefania
Hi Stefania,
you're right!!
thank you!
Bye Chiara