Color coding based on rank in pivot table

[mightyqlikers]

Dear team,

please find the attached.

and in that i want to give the color of max 2 of sum(perc) green and min 2 of sum(perc) as red as per the rank.

for example in CA column rank 1&2 should get green and 4&5 should get red like wise for all the columns.

please help        

[swuehl · Accepted solution]

Maybe use a background color attribute expression like

=If(

rank(total if(sum(PERC) <> '0',sum(PERC))) <= 2,LightGreen(),

If(rank(total if(sum(PERC) <> '0',-sum(PERC))) <=2 , lightred())

)

[mightyqlikers]

Perfecto  stephen.

Thank you.