Set Analysis help.

[spividori]

Hi.

In my example I have a pivot table with fixed AñoMes in the last four months.

I need to select a value in the Line field and display only the values ​​of this selection within 4 months.

Regards.

[spividori]

Someone could help me?. Thanks.

[#3]

Hi Sandro,

You sould use $ and not 1

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

[spividori]

Hi Jairo.

Thanks for responding.

I need that the period to be static or fixed .

Regards.

[ronaldocarrijo · Accepted solution]

Try This:

[spividori]

Hi Ronaldo.

It is excellent!, Just what I need, works perfect. Thank you very much.

Regards.