Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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())
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())