Highlighting Max and Min Values

[#1]

Hi

I am trying to highlight the max and min percentage, using a straight table with expressions individually for all months works,

but I want to use one expression keeping month has my Dimension and want to highlight the max and min percentage

I have attached a qvw file for the reference, with table 1 and table 2

I need the second table to be same as first one

I am not sure what I am doing wrong

Please help

Regards

Arjun

[#2]

You will have to aggregate the value in load script as a new field.

For example

LOAD

     Product,

     sum(Sales) as salessum

    Resident Table

group by Product

;

Then in the condition you need to give if(sum(Sales)=max(salessum),red(),green())