Challenge Color Background dimension (on a pivot table)

[cafcptg2011]

Hi,

I came across with a problem to set the background color of 2 dimensions of pivot table based on their max value.

I have attached a qvw file to help.

My pivot table:

What I need:

Can anyone please help me to accomplish that.

Thanks in advance,

CAFC

[#2 · Accepted solution]

Try expression like this:

=if(Type=only({<Type={"=rank(aggr(sum({< Article={'AAA'}>}Value),Type))=1"}>}Type) ,red())

regards

Darek

[aaronnash]

Dariusz hit the nail on the head (and beat me to it!)  If you would like your example back with Background Colors populated, it is attached.

[#4]

I know, i prepared similiar one.

Only one thing i'am not sure - try to add listbox for size and then select one value. Why total is green?

[cafcptg2011]

thanks to you guys! it works nice!

[aaronnash]

Dariusz does bring up a good point.  Is the filtered total coloring going to cause issues?