Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
=If(Revenue = Max(TOTAL <Make, Mode>Aggr(Sum(Revenue), Make, Mode, Region)), Red())
Try this
=If(Revenue = Max(TOTAL <Make, Mode>Aggr(Sum(Revenue), Make, Mode, Region)), Red())
Sweet, thanks for the quick reply