Forum Discussion
Different filter in one table
The description is not that clear to understand your scenario, could you post some sample data in plain text?
Eric_Zhang
Following scenario:
I have several fields who look like this:
Each field represents a certain indicator. F.e. This data represents the Indicator 1.1.
I would like to combine all these different fields/indicators because I want to put all the data in one table.
Therefore I use the "manage Relationships" function.
After that, I want to filter these different indicators. For example: For Indicator 1.1, I only want to see the countries which have an CAGR between 0-20.
For Indicator 1.2, I only want to see the countries which have a CAGR between 80-100.
However, when I activate the second filter (80-100), it also filters the countries which have a CAGR between 0-20.
Again, is it possible to have different filters in one table without replacing each other when I look up certain countries?
Any ideas?