Highlight highest column

[ivandrago]

Hi,

I have the attached document, I want to highlight in red the cell which has the highest value for each of the columns "Order Price" and "Products"

Thanks

[julian_ortiz · Accepted solution]

Hi Ivan.

Something like this? Using Rank()

Check the property BackGround Color

Regards

[maxgro]

if(sum(OrderPrice)=max(total aggr(sum(OrderPrice),MonthYear)),rgb(255,0,0))

if(count (distinct productId)=max(total aggr(count (distinct productId),MonthYear)),rgb(255,0,0))

[#4]

Hi Ivan,

Go to properties-> visual cues -> and set the background color as red and define a formula for upper limit or lower limit as per your requirements. I have implemented the requirement you asked for in the following attachment as example. Hope this helps.

Regards,

Sonya

[MarcoWedel]

Hi,

other versions of the background color expressions:

Pick(Rank(Sum(OrderPrice)), LightRed())

Pick(Rank(Count(Distinct productId)), LightRed())

hope this helps

regards

Marco

[MarcoWedel]

or maybe even shorter:

Pick(Rank([Order Price]), LightRed())

Pick(Rank([# Products]), LightRed())

hope this helps

regards

Marco