Pivot table multiple expression as column find the max row value
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?
