How to apply changes in next Item in Filter section.

TEG asked on June 10, 2019

Hi,
We are using csv connection for pivot table. I have State and County presents in the data.
For Example My data looks like below:
State
County
New York
Albany 
New York
Allegany 
New York
Bronx 
Tennessee
Anderson 
Tennessee
Bedford 
Tennessee
Benton
 
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.

Regards,
TEG

1 answer

Public
Tanya Gryshko Flexmonster June 12, 2019

Hello,

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.

Regards,
Tanya

Please login or Register to Submit Answer