Dimension Data conditional Format

[vardhancse]

Hi,

I am trying to change the color of the dimension in a pivot table based on one condition.

Dimension: Period

Value: 2013,2014

Condition:if(2013>2014),Green,Red

Can please let me know

[vardhancse]

Hi Gysbert,

thanks for your reply, I want the result as below like which ever value in 2012/2013 was higher that color need to be green other should be Red

[Gysbert_Wassenaar · Accepted solution]

See attached example.

[vardhancse]

Thank you so much Gysbert.

[gautik92]

Use this in Expression->Background Color or Text Color

=If((Sum({<Year='2013'>}Amount))>(Sum({<Year='2014'>}Amount)),Green(),Red())

[vardhancse]

Hi solution provided by gwassenaar‌ was exactly my requirement.

[vardhancse]

Hi Gysbert,

One more help is that if the value for 2012 and 2013 was blank it should show blank in the YOY, instead it is showing symbol.

can please help me out.

[vardhancse]

Hi got it, added isnull function for the measure and all blanks were showing -