Show Latest 24 Months of data in the Pivot Table using expressions

[#1]

Hi,

I have a Pivot table,

I need to show only 24 months of data by default.

and i have a checkbox, when i click that, i need to show 72 months of data in the same table.

How can i do that?

[jonathandienst]

Hi

You can create a variable in a variable input box, a button with a set variable action or a control field in a list box/multi box that will control your expression(s) to show either 24 or 72 months.

I suggest that you post your application so that someone can show you how to achieve one of the above for your model.

Regards

Jonathan