Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a scenario to highlight the maximum value in each row and each column of a pivot table.
If the cell value is maximum in each column, it has to be highlighted in yellow. if the cell value is maximum in a row, it has to be highlighted in blue.
if the cell is the maximum in both the row as well as in column it has to be highlighted in Orange.
I tried with Aggr and Rank functions. but couldn't make it work.
Any help is much appreciated.
Thanks
Sarathi
PFA
this will also work..
Background Color
if(sum(Count)=Max(TOTAL Count),RGB(250,192,144),
if(sum(Count)=Max(TOTAL <Country> Count),Blue(),
if(sum(Count)=Max(TOTAL <User> Count),Yellow())))
Text Color
if(sum(Count)=Max(TOTAL Count),Black(),
if(sum(Count)=Max(TOTAL <Country> Count),White()))
Yes the expression could be simplified, try:
if(sum(Count)=Max(TOTAL Count),RGB(255,128,64),
if(sum(Count)=Max(TOTAL <Country> Count),RGB(117,153,213),
if(sum(Count)=Max(TOTAL <User> Count),Yellow())))