Forum Discussion
Different filter in one table
Hey Community,
my question is: How do I use different filters for one column in the same field?
The problem is that I have several fields with the same data structure.
Within the data structure, there is a column "country" and an other column "CAGR".
The columns CAGR always have different values and also are filtered differently.
For example: Column 1 CAGR is filtered: greater than or equal to Zero and Less than or equal to Zero
Column 2 CAGR is filtered: greather than or equal to 80 and Less than or equal to 100
The column "country" always consists of the same countries. In order to combine these several fields, i use the "manage relationships" function. However, when I put the different data structure in one table, the COLUMN 2 CAGR replaces the COLUMN CAGR 1 filter so that I am not able to see the other countries. What to do?
Thank you in advance!
3 Replies
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?
