Highlight max and min values in pivot table by rows

[roberto99]

Hi, i have a pivot table whit 2 dimension (Art and Cod_t) and mesure (Fir), i want to highlight the maximun and minimun value per row.

whit this i can only point to the row point whit de maximun value and minimun value.

iF(AVG(Fir)=RANGEMAX(TOP(TOTAL avg(Fir),1,NOOFROWS(TOTAL))),GREEN()

,IF(AVG(Fir) = RANGEMIN(TOP(TOTAL avg(Fir),1,NOOFROWS(TOTAL))),yellow()))

thanks

[sunny_talwar · Accepted solution]

Try this

for Max

If(Avg(Fir) = Max(TOTAL <Art> Aggr(Avg(Fir), Art, Cod_Tienda)), Green())

for Min

If(Avg(Fir) = Min(TOTAL <Art> Aggr(Avg(Fir), Art, Cod_Tienda)), Yellow())

[roberto99 · Accepted solution]

It works perfect , thanks

[tahernia_p]

your color expression is amazing 👏 it solved my problem too, Many thanks