Hide and Show column based on filter selection

[pallavie]

Hi Team,

I am using Pivot table, Dimensions are District and Territory .

When we select District filter we should see District column and territory column(hide) in table, and if we select both district and territory we should see only territory column and district should be hide and If selection is only territory we able to see only territory column and district(Hide).

I have used getselectioncount(district)>0 in show condition so If I select only territory filter district column is hide, If selection made any district , it will be seen.

What expression I should use to hide district column if we select has both territory and district.

Or is there any other way to approach this.

Thanks

[anat]

(getselectioncount(district)>0 and getselectioncount(terrotory)>0) or getselectioncount(district)>0

[pallavie]

Hi Anat

Thanks for helping,

I have tried the expression but it is not working as expected.

Thanks and Regards