Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I have to compare value between 2 field like that :
FIELD 1 | FIELD 2 | |
TOTAL | 100 000 | 100 000 |
A | 50 000 | 100 000 |
B | 20 000 | 100 000 |
C | 10 000 | 100 000 |
D | 5 000 | 100 000 |
E | 15 000 | 100 000 |
Like you can see, for the field 1, I have categories A B C D E but for field 2, I have no categorie, so he display me 100 000 everywhere, but I would like to have 100 000 only for the total in field 2. something like it :
FIELD 1 | FIELD 2 | |
TOTAL | 100 000 | 100 000 |
A | 50 000 | - |
B | 20 000 | - |
C | 10 000 | - |
D | 5 000 | - |
E | 15 000 | - |
thanks in advance for reading me
Hello, I come back to u to say u that I found solution.
I needed to do :
if dimensionality() <> 2, .....
Hello @Fred12, would you be able to share a dummy dataset like the one you are using for me and other members to test? I'm not sure I've fully understood your request. Thanks! 😊
Hello, I come back to u to say u that I found solution.
I needed to do :
if dimensionality() <> 2, .....