Different filter in one table

[Lenni96]

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!

[Eric_Zhang]

@Lenni96

The description is not that clear to understand your scenario, could you post some sample data in plain text?

[Lenni96]

@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?

[Lenni96]

Any ideas?