pivot table

[mario-sarkis]

hi

this is what i need and hope you can help have a pivot table:

Expression 1	Expression 2
6%	7%
7%	5%
5%	7%
8%	10%
1%	1.5%

i need a red color in Expression 2  is Expression 2 greater then 1% of Expression 1

Expression 1	Expression 2
6%	7%
7%	5%
5%	7%
8%	10%
1%	1.5%

Any one can help ?

[krishna20]

Hi,

Goto Expressions tab-> Select your Second Expression -> Expand it by clicking + -> Selct Text Color-> Write your Expression like this.

If(Sum( Field in Expression 2)> Sum(Field in Expression1), Red(), Black())

[tresesco]

Try like shown in the image below:

Note: Exp1, Exp2 are actually labels of the expressions. For %, you might have to compare like: If ( (Exp1*10)>1, red())