Pivot table coloring

[#1]

Hi,

IN a pivot table I would like to have a red color if my values is not the same. In the enclosed example:

-A works fine because I have the same values

-B works fine because i have different sums

- C does not work because the sum over Dim1 is the same. How can i write an expression that color this red when im looking at Dim1? I tried aggr but t did not get it to work.

/D

[renjithpl]

Try

if(sum(Value1)<>sum(Value2), RGB(255,0,0), RGB(125, 0,0))

regards

[renjithpl]

sorry dude, i miss understood your question.

[#4]

I tried:

if(aggr(sum(Value1),Dim2)<>aggr(sum(Value2),Dim2), RGB(255,0,0))

But that did not help..

[johnw]

So you want the value in red if ANY of the values at the Dim2 level differ, even when rolled up to just Dim1? If so, I believe this does the trick:

if(min(aggr(sum(Value1)<>sum(Value2),Dim1,Dim2)),lightred())

The min() uses the fact that true() is -1 and false() is 0. So when rolled up, the min() says that if ANY of the values at the Dim2 level differ, then the condition is true.