Forum Discussion

derekma19's avatar
derekma19
Frequent Visitor
2 years ago
Solved

Data filtering based on the selection from a different table

Hi all, I would like some help on how to design the following report.

 

I have the table [VALUES] below

And I want to filter that table based on the table [FILTERS]

In the report I will like to have a dropdown displaying the column "Filter" for the table [FILTERS], when the user select one of the options from 1 to 6 the table value will include and/or exclude the related columns. For Example, If user selects Filter = 1, the table would filter in Option 1 in [VALUES] = A1 and filter out Option 2 in [VALUES] = B2. The below would be the expected output for Filters 1, 2 or 3.

 

I'm thinking in created a calculated table [FILTERS-MOD] based on [FILTERS] and then just reading the columns for a filter.

Something like:

Then using this [FILTERS-MOD] table to create a [VALUES-MOD] table based on the filters above, but not quite sure how to proceed and even if I am going in the right direction

Any suggestion is more than welcome.

 

Kind Regards