Highlighting highest value in a pivot table

[flex_98]

Hi all,

I'd like to highlight the highest value in a pivot table. Thereby I´m facing the following issue:

	Mon	Tue	Wed	Thu	Fri	Sat	Sun
1 am	10	15	12	20	5	3	1
2 am	15	14	18	19	29	6	7
...

I already figured how to highlight the highest value per row [if(rank(vIncomingOrders)=1, green())], but I need to highlight only one value for the whole pivot table.

That´s what I need:

	Mon	Tue	Wed	Thu	Fri	Sat	Sun
1 am	10	15	12	20	5	3	1
2 am	15	14	18	19	29	6	7
...

Can you please help me?
Thanks!

Felix

[JordyWegman]

Hi Felix,

Try this, the TOTAl will evaluate over all values.

IF(
  Rank(TOTAL vIncomingOrders)=1, 
  green(),
  null()
)

Jordy

Climber 

[flex_98]

Hi Jordy,

thanks for your quick response.
Unfortunately it didn´t work for me as it gave me the same result.

[Kushal_Chawda · Accepted solution]

Let's assume your expression in vIncomingOrders is below

sum(Qty)

then, in expression background color you can write below expression

=if(sum(Qty) = max(total aggr(Sum(Qty),Time,Day)),Green())

Where Time is the field that contains time value, 1am,2am...

and Day is the field that contains Day valus Mon,Tue,Wed.....

[flex_98]

Hi Kush141087,

vIncomingOrders already contained the sum of all quantities.
After I changed my underlying formula so that it´s not containing the sum already, it worked fine for me.

Thanks a lot! 🙂

[nverdier]

Hi 
Is it possible to get the lowest highlighted? with this formula?

[flex_98]

Hi,
this should be possible, too.
Just replace Max() with Min().