Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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())
It works perfect , thanks
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())
It works perfect , thanks
your color expression is amazing 👏 it solved my problem too, Many thanks