Help on Background color for Calculated Dimenssion

[#1]

HI All,

I have a calculated dimension and a Month field in the pivot table:

Calulated field is defined as

= If(Range <= 5, '0 < X < 5',

  If( Range<= 15, '5 < X < 15',

  If(Range <= 30, '15 < X < 30',

  If( Range <= 45, '30 < X < 45'))))

The expression used in pivot table is  Count of Products.

So the table looks like  :

          0 < X < 5       5 < X < 15      15 < X < 30       30 < X < 45

Jan      121               555                  231                   100

Feb       100               200                  600                    500

Now the background colour should be based on my Calulated field.

For 0 < X < 5 it should be green

For 5 < X < 15 it should be light green

For '15 < X < 30 it should be Orange

For '30 < X < 45 it should be Red.

How to implement this Can any one help me on this?

[kristoferahlin]

Click the plus sign to the right of the calculated dimension and add the following expression under Background color:

= If(Range <= 5, Green(),,

  If( Range<= 15, LightGreen(),

  If(Range <= 30, RGB(255,165,0),

  If( Range <= 45, Red()))))

[sujeetsingh]

On Dimension tab >>Click on + sign of dimension

>>Then there comes a option of Expression for background>>

>> Then write this

If(Range <= 5, Green(),,

  If( Range<= 15, LightGreen(),

  If(Range <= 30, RGB(255,165,0),

  If( Range <= 45, Red()))))

[vinay_hg · Accepted solution]

in the expression --> background color write same expression

i.e.

= If(Range <= 5, rgb(0,255,0),

  If( Range<= 15 and Range =>5, RGB(0,150,0), //150 is for lighter green u can reduce or increse this no as per ur req

  If(Range <= 30 and Range =>15, RGB(),//fing color code from color pallette

  If( Range <= 45 and and Range =>30, rgb()))))

but if true give RGB(255,0,0) for red, like wise give for other colors.

write the expression inside -->expression -->background color see attachment

[#5]

HI ALl,

Thank you for the response. Actually I tried to do for Expression Bacground.

= If(Range <= 5,Green(),

  If( Range<= 15, LightGreen(),

  If( Range<= 30, Yellow(),

  If( Range<= 45, LightBlue(),

  If( Range<= 60, LightCyan(),

  If( Range<= 75, LightRed(), Red()))))))

But for all values it is showing RED only..WHat is the problem?

But in actuall data we have values for all ranges.

[#6]

It is because of selection of Range value in the Application. Actually there is an selection box for user. That is why it is giving red.

Is there a way where I can overcome the problem?