Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm developping a Pivot Table and I would like to highligt some values. In the sample here below, I would like to get a red font when the value of the columns "Conf..." is greather than the value of the column "SO Avg".
These 2 columns are sum values. It seems that the visual indicator compares the value of my column "Conf..." with the sum of the column "SO Avg" of the whole Pivot table and instead of the sum of my line.
Could you please help me ?
Thanks in advance.
JAC
Have you tried to do that here
Dear Alan,
Thanks for your answer. It's a good workarround and it works. I'm just surprised to see that the row header is coloured like the first row !
Does that mean that the "Visual indicators" is not fully functionnal ?
I would tend to avoid using the Visual Indicators
and always use the Expression Definition Dialogue like above