How to add reference table to the interactive filter when the Filter based on " Cascading Filter"

[rashmin3]

Hi,

I have an requirement based on the category filed interactive filter, the report should display the data in the dashboard.

I have created the cascading interactive filter for category and i am using my custome table in the intactaive filter.

The dashboard contains 2 reports on 2 different tables but the the interactive filter i created contain only one table so it is showing data for only one report, now i need to add another table to the cascading interactive filter but i am not able to add. Anyone knows how to add 2 tables to the cascading interactive filters.

Thanks and Regards,

Rashmi

[Holly Hook]

Not sure why you've chosen a cascading option? We just had the same question last week and switched the type to be reference and it worked much better. Here's a doc link with the different kinds of interactive filters: Available Interactive Filter types

[strurgeonge]

To add a reference table to an interactive cascading filter, begin by ensuring that the reference table contains all necessary hierarchical data required for filtering. This table should include columns representing each level of the cascading filter, arranged in a parent-child relationship (e.g., Category → Subcategory → Item). Once the reference table is prepared, link carsflow it to the filter configuration in your application or reporting tool.