Hide and show column

[smilingjohn]

Hi All, 

I have a inline table "Category"   which I am considering as a filter pane. 

If I select Category (Cosmatic) then i want to hide my 3 columns (football,cricket and movie) and show only one column BeautyProduct in my pivot table . 

and when i dont select Category then BeautyProduct should be hidden and  3 column  (football,cricket and movie) should be displayed. 

How can I cahive this ?

Thanks in Advance

[MayilVahanan · Accepted solution]

Hi @smilingjohn 

Try like below

=GetselectedCount(Category)= 0 for 3 columns.

For BeautyProduct , provide the condition like below

=Category='Cosmatic'

Hope it helps