Get Free Trial
Get Free Trial

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

3 answers

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

Public
Devesh August 7, 2019

hello Tanya,
I have a similar type of requirement but with .net db connection with flexMonster compressed data (instead of CSV). 
Can you please help me on how can I achieve this?
Thanks

Public
Vera Didenko Flexmonster August 8, 2019

Hello,
 
Thank you for your question.
 
We kindly suggest using : in SQL query alias to define a hierarchical connection between dimensions.
 
Please consider the following example: 

SELECT category AS ‘Category’, subcategory AS ‘+Category:Subcategory’
FROM table_name;

The hierarchy structure is defined with query alias. The Category field is the first level of the hierarchy and Subcategory is the second level of the hierarchy. 
 
Please let us know if this works fine for you.
 
Best Regards,
Vera

Please login or Register to Submit Answer