Delta between months in Set Analysis

[c_pannese]

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.

[s_santalucia]

Hi Chiara,

this is possible if you remove the where condition in

<< as-of-table>>

Regards

Stefania

[c_pannese]

Hi Stefania,

you're right!!

thank you!

Bye Chiara