Background Color

[#1]

Hi,

I am trying to change the backgroumd color of a specific expression column based on criteria in pivot table. But it is not getting changed.I have more than one dimension and more than one expression in the Pivot table.

This is the code i am using to change Background Color

If((Quantity * price)>Tprice,Green()).

The color is not getting changed.Please suggest.

[#2 · Accepted solution]

Hi,

I found the issue causing the problem.In number i have choosen the percent and the values i have passed to compare was not in percent format.

It is working in two ways through background color and the Visual Cues. If we try to change the colour through the background option of the expression it is changing the expresssion column heading color as well. Also if the color change is based on if else condition and ur expression column heading is displayed more than once (multiple dimesnion) then coumn headings will be with different colours.

In Visual cues it is working fine