Hello
I would like to color code the background of the dimension values in a straight table, somewhat like the "strip every" function but for every new value. With the following example table;
| Dimension1 | Dimension2 | Expression |
|---|
| A | 1 |
|
| A | 2 |
|
| A | 3 |
|
| B | 1 |
|
| B | 2 |
|
| C | 1 |
|
| D | 1 |
|
| D | 2 |
|
| D | 3 |
|
| D | 4 |
|
I would like the background color of Dimension1 to be grey for the values A, white for B, grey for C, white for D and so on.
Is this possible? I have tried with the above() function but that doesn't seems to do the trick. The values of Dimension1 in the real data is not as simple as A-Z.
