I have a very simple table with projects and their values (cf image).
I am trying to create a dimension to filter the project based on their values.
The values of this dimension would be for example 'Below 1 M€', 'Above 1 M€', 'Above 5 M€', 'Above 15 M€', 'Above 50 M€'. I tried the following script (the following script:
However when I filter when the value 'Above 5 M€' for example, only the projects between 5M€ and 20M€ are shown. There should also be the ones above 100M€.
How do one attribute several dimensions to a field ? It's a problem of creating a multi-dimension I guess.