To select number of months in the table under - DATA HANDLING

[Serena07]

Hi all,

I have to write an expression for selecting only 3 to 4 months in the table.

like to fix a number max of months selected.

If  the number is exceeded, we must display a message in place of the pivot table, something like “Please reduce the number of months to display the data”

Can someone please help what to write in the Calculation Condition. in it i can see the following get functions..

[arulsettu]

Maybe like this

If(GetSelectedCount(Month)>4,'Please reduce the number of months to display the data')

[Kushal_Chawda]

@Serena07  In calculated condition put below

=getselectedcount(Month)<=4

In displayed msg put your message

[Serena07]

hi, Kaushal i tried this only

but when I selected the Year 2020, the pivot table is not showing the message.