Rank Accumuleted values troughout the day

[#1]

Hi,

now I've managed to rank single net values troughout the day.

However, anyone know a way to rank the ackumulated balances?

For instance, in the below example I wish to present the MAX/MIN accumulated as marked in blue.

Tnanks in advance,

Olle

[#2]

Sample file attached.

//O

[#3]

hi,

To change the color u can give background color expression like this

=if( [Full Accumulation] = Max([Full Accumulation]) or [Full Accumulation] = Max([Full Accumulation]),Blue())

Hope this helps. Vivek

[#4]

Hi Vivek,

sorry, maybe my description was a bit unclear.

I need a separate table box to pick up the min/max accumulated values.

No need for color change

Regards,

Olle

[jonathandienst · Accepted solution]

Hi

See attached - I think this is what you are after.

HTH

Jonathan

[#6]

Genius!

Thanks Jonathan!