Help Needed: Highlighting Maximum Values in Each Column of Pivot Table

[Sadeesh]

Hello everyone,

I have a pivot table with the following dimensions: DB (row) and week_details (column), and I’m using a measure to count values. I want to highlight the maximum values in each column (week_details) using the following expression:

if(Count({<DB=>} TM_NO) = Max(TOTAL Aggr(Count({<DB=>} TM_NO), DB, week_details)), RGB(255,0,0))

However, this expression is highlighting a single maximum value for the entire table, rather than highlighting the maximum values in each column. Could someone please advise on how to modify the expression to achieve the desired result of highlighting the maximum values within each column?

Thanks in advance for your help!

[Chanty4u]

Try this by removing total 

if(Count({<DB=>} TM_NO) = Max(Aggr(Count({<DB=>} TM_NO), DB, week_details)), RGB(255,0,0))