Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want a code which will highlight my top 3 sales in a pivot table with red color. ?
Regards
Renjith
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())
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())
its showing red for all the entries...
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())
For background color in expression, use the following expression
If(Rank(Sum(Sales])<= 3),RGB (255,0,0))