Color background based on top 3 sales

[renjithpl]

Hi All,

I want a code which will highlight my top 3 sales in a pivot table with red color. ?

Regards

Renjith

[swuehl]

Use a background color attribute expression (open attributes by clicking the + next to the expression name in expression tab):

=if(rank(sum(Sales))<=3,lightred())

[renjithpl]

its showing red for all the entries...

[swuehl · Accepted solution]

Ok, you probably use more than 1 dimension and want the top 3 sales across all values? Try adding a TOTAL qualifier:

=if(rank(TOTAL sum(Sales))<=3,lightred())

[#5]

For background color in expression, use the following expression

If(Rank(Sum(Sales])<= 3),RGB (255,0,0))