Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
X 1 | X 2 | X 3 | X 4 |
---|---|---|---|
Z1 | 3 | 4 | 5 |
Z2 | 4 | 2 | 1 |
Z3 | 1 | 5 | 9 |
I am trying to use pivot table and create color like this- so minimum of every row should be highlighted (either by text or background color).
I am not able to figure out.
Hi,
Can it be like in the attached file? An expression for the color is written in each PivotTable expression. Red color was allocated the minimum value in each line.
Regards,
Andrey
Hi,
Can it be like in the attached file? An expression for the color is written in each PivotTable expression. Red color was allocated the minimum value in each line.
Regards,
Andrey
Great work Andrey !
Thanks Omar!
thanks omar for quick reply and good answer - it works perfect