How to hide & show specific dimension in chart

[Naps_230]

Hi Team,

I have one scenario. Please help on that

I have 3 buttons.

ex- Country, State, City

3 Dimensions & 1 measure

ex- Country,State,City  and  measure is Sales

Requirement:-

1. Country,State,City  are Dimension and  expression is Sales in Straight Table.

2.when i click on Country button , i want to show only Country, Sales in Straight Table.Other dimension are hide automatic.

3.when i click on State button , i want to show only State, Sales in Straight Table.Other dimension are hide automatic.

4.when i click on City button , i want to show only City, Sales in Straight Table.Other dimension are hide automatic.

[Qrishna]

Something like this?