Skip to main content

Hi Friends,

 

Please see the attached the screenshot. I would like to color each products and then need to show each product wise high value and minimum value on row wise.

 

I used the calculation like this :

 

if ( [AUM per Branch])=WINDOW_MAX( [AUM per Branch]) then 1 else if ([AUM per Branch])=WINDOW_MIN([AUM per Branch]) then 1 else 0 end end

and this calculation into color legend.

 

How to achieve this?

 

Please suggest your comments , Thanks in advance

 

Regards,

Sooraj

6 answers
0/9000