We are using csv connection for pivot table. I have State and County presents in the data.
For Example My data looks like below:
I have kept State and County in filter section. It is working fine.
State Dimension is showing : New York and Tennesse.
County Dimension is showing : Albany, Allegany,Bronx,Anderson,Bedford,Benton.
Once i select only new york state from my state filter, in county filter it should show only Counties of new york, but it is showing counties of other sates also, basically cascading effect between two filters are not working.Is there a way to get the cascading effect from one filter to other in filter section.
Thank you for writing to us.
We suggest defining a hierarchical connection between these dimensions. Here is how it will look like in your CSV file:
State, State:County New York, Albany Tennessee, Anderson
Please let us know if such an approach works for you.