How to change color in Pivot table?

[soha1902]

Hi All,

In pivot table, we are using 3 dimensions and 1 expression custom_value. Like below

But in pivot table it showing so many colmns. These column are loaded through inline.

Now I want to change cell color based on some condition. but there is only one expression and it showing many columns so please guide me where I need to write expression.

Thanks....

[#2]

Try this Expression Background color  if(PivotDimension='Some',RGB(179,179,179),if(expression>5,RGB(59,59,59)))

Regards,

Chinni Kanna