Highlight fields in pivot table

[#1]

Hi guys,

I have a pivot table with some numerical values and I need some formula in order to highlight them either green or red. What I need to do is to calculate if the numbers in the rows under the first one (the first row stays in place and it's always green) are either +- 5% of the number in the first row that's above it. How do I do this?

Thanks,

Adrian

PS: I have the free version, so I'm not able to open any file.

[#2]

Hi,

If I'm using Top(expression) it doesn't take into account any number after the second one. Basically, if the first number in the column is 100, the second one is 95, let's say, 95 will be green, which is good, but the rest of number will be red, regardless of their value..

Adrian

[rubenmarin]

Hi, Check attachment, in simple example it works, maybe your table has more dimensions and need to use a TOTAL or something, can you post a sample?

Or you can use directly Top(expression) to check what value is used to compare, it will give you a hint of how to solve.

[#4]

Unfortunately, I cannot open attachments for I have the free version

What formulas did you use?

[rubenmarin · Accepted solution]

The same formula, but it works in a simple example:

If (Value<Top(Value)*1.05 and Value>Top(Value)*0.95, green(), red())