Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have created a pivot table which has the following columns;
Each Product Line row has a target for measuring performance, which is the guiding factor for color coding for that specific row.
Example;
For Product Line - 6A, OTS Target is 9 days.
Now in that row cell data which is above 9 days need to be colored in 'Red' and cell data less than equal to 9 days need to be colored 'Green', while row cells which have no data should remain as is.
Regards,
Dev
Hi,
For each expression or dimension, you can just expand it and write an if statement for the background colour