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

[prashantbaste]

Hi Sasi,

When you add dimension, you can see   , you can click on it and will get some more options  as -

Click on 'Background Color' option & write condition as -

If(Period='2013',Green(),If(Period='2014',Red()))

It will show color in background.

Hope this will be helpful for you.

--

Regards,

Prashant P Baste

[vardhancse]

Hi,

Not based on 2013 and 2013, we have one expression and the condition is 2013 Vs 2014

[tamilarasu]

Hi,

Can you post sample data?

[prashantbaste]

Then same thing you need to do in expression -

In 'Background Color' of expression, you can write the condition as -

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

I hope now I have made right assumptions...!

Is this the solution that you were looking at?

--

Regards,

Prashant P Baste

[vardhancse]

PFA sample QVW

[vardhancse]

Can any one help me out..

gwassenaar‌

[Gysbert_Wassenaar]

Add the conditional color expression to the dimension Background Color setting instead of that of the chart expression.

[tamilarasu]

Hi Sasi,

Check out the below attachment.

[vardhancse]

My requirement is

if value of 2013 is > 2014, then that value should be green, similarly wise versa.