Pivot Table Highlight Max Column

[sidjustice]

Hi I have some sample data that needs to be shown in a pivot table. Now I need to highlight the column (say background color) which has the highest revenue when the Mode column in collapsed. Like so

Make	Mode	Region	Central	East	West
Honda	Nom		12466	12831	11653
	Sub		11126	11433	10534
	Tur		14259	14880	13155
	vs		9278	8656	8987

So I far I have been trying with the Max, but not able to get it to work

Max ( aggr (NODISTINCT sum(Revenue) , Make, Mode, Region))

Attached qlikview document with inline data

Appreciate any help, Cheers

Sid

[sunny_talwar · Accepted solution]

Try this

=If(Revenue = Max(TOTAL <Make, Mode>Aggr(Sum(Revenue), Make, Mode, Region)), Red())

[sidjustice]

Sweet, thanks for the quick reply