Set Analysis

[spividori]

Hi.

In my example, the pivot table "Ult 4m" I take the current month and the previous 3 months: oct 13, sep 13, ago 13, jul 13. But now I need to take the 3 months without current: sep 13, ago 13 jul 13.

Regards.

[Anonymous]

Sandro

Replace your current dimension with this Calculated Dimension :

     =if ( not month(AñoMes)  = month(today()) , AñoMes )

And Tick Suppress When Value is null.

Best Regards,     Bill

[rajni_batra · Accepted solution]

Try

SUM({1<AñoMes={">$(=Date(AddMonths(Max(AñoMes),-4),'MMM YY'))  <$(=Date((Max(AñoMes)),'MMM YY'))" }>}Cantidad)

Regards,

Rajni

[spividori]

Thanks Rajni, is what I wanted.

Regards.