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
Hi Sooraj,
You need to set the calculation to get the desire result.
~Tushar
If it helps please mark the answer as correct and helpful.