Visual Cues in Pivot with different limits

[stekol61]

Hi1

I have a pivot table vithe 6 dimention values and 8 different expressions. See attached file

I have also loaded a list of target values. It's differet targets for each dimentions.

E.g.For one expression, Store A has a target of 99,55, store B 99,38 etc.

What i want to is to set the coulur to Red of an expression/dimention if the value is below the target value.

How can I do this?

[jcs_2015]

Add an expression in the advanced formatting section for the respective Expression(s)...something like this:

[vishsaggi]

As Jim suggested use the background expressions based on your Target values for each expression field.

Attached is the sample based on your excel. Changed the Field value for Field A lesser than target to get the red background. Check and let us know. Add the remaining target values as mentioned in the app.