Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear expert,
I have a pivot table, one dimension and multiple expression columns. I want compare all columns value and rank it for every dimension row.
Dimension | Exp1 | Exp2 | Exp3 | Exp4 | Exp5 | ... |
A | value | value | value | value | value | ... |
B | value | value | value | value | value | ... |
... | ... | ... | ... | ... | ... | ... |
For example, I want get the information is which expression column is the Max value, which one is the second, third... for dimension value "A". Then I can use the result to make the different cell's background color.
However, for most of the expressions has different logic. i guess only just can compare values size for every row? But how to make it works?
So experts have any suggestion for this question?
Thanks a lot for your help!
Add another expression with: rangemax(Expr1, Expr2, Expr3, ...) whereby you could use the labels of the expressions or their column() index.
- Marcus