Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
stekol61
Creator
Creator

Visual Cues in Pivot with different limits

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?

2 Replies
jcs_2015
Contributor III
Contributor III

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

2017-03-02_13-16-50.png

vishsaggi
Champion III
Champion III

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.