Highlighting Max and Min Values

Wed, 26 Nov 2014 13:22:53 GMT

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

Re: Highlighting Max and Min Values

Wed, 26 Nov 2014 13:42:21 GMT

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())