
Contributor III
2019-02-05
10:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Highlight max and min values in pivot table by rows
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
3,381 Views
2 Solutions
Accepted Solutions

MVP
2019-02-05
10:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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())

Contributor III
2019-02-05
11:01 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It works perfect , thanks
3,386 Views
3 Replies

MVP
2019-02-05
10:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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())

Contributor III
2019-02-05
11:01 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It works perfect , thanks
3,387 Views


Contributor II
2020-10-18
02:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
your color expression is amazing 👏 it solved my problem too, Many thanks
2,870 Views
