How to conditionally add color only to the data inside the pivot table not the labels.

[#1]

Hi,

I need to show background colors for the measures depending on their vaqlues.I am able to do that by setting the expression in the background option for the measure.But i need to display the data with the background color ,not the label.At present the label is taking the bgcolor of the first data cell.How do i do that?

Please help.

Thanks in advance.

[#2 · Accepted solution]

hi Sandhya,

I suggest yuo do it through visual effects sheet, no setting the expression in the background option for the measure.

See my attached file.

Best regards.

[#3]

Hi,

Thank you.

But my requirement is something like this:

I have to plot measure1 and measure2

Need to highlight measure2 in different colors based on the ratio of measure1/measure2.

Without writing the expression and not adding another measure to indicate the ratio how do i acheive this?

Please help.

[#4]

I can not explain in words because my English is poor.
Watch this example ......
Let me know

Daniela

[#5]

The picture is clearer now?

Daniela

[#6]

Are you setting the colour in the Expression tab, or the Visual Cues tab?

[#7]

Expression tab!

Daniela

[#8]

Thanks a lot.

But i am not keeping my measures in columns i am displaying it in rows.

My pivot tab structure is something like this->

			Year(+)
			Quarter(+)
Country(+)	City(+)	Product(+)	Month
A	B	C	Jan	Feb	Mar
		ActualQty
		BudgetQty

I need to color only the data values (excluding the label) of actualQty like->

if actualQty/BudgetQty >=.8 red color,if the ratio<=.5 orange color else yellow.

Please suggest me how to use the dimensionality with rowno().

[#9]

Thanks a lot.

But i am not keeping my measures in columns i am displaying it in rows.

My pivot tab structure is something like this->

			Year(+)
			Quarter(+)
Country(+)	City(+)	Product(+)	Month
A	B	C	Jan	Feb	Mar
		ActualQty
		BudgetQty

I need to color only the data values (excluding the label) of actualQty like->

if actualQty/BudgetQty >=.8 red color,if the ratio<=.5 orange color else yellow.

Please suggest me how to use the dimensionality with rowno().