Skip to Content
0
Former Member
Jan 18, 2013 at 03:42 PM

Custom sort and Multivalue error

13 Views

Hi

I have two dimensions ie branch code, Month Year and one measure ie Revenue. I have created a variable for rank ie

V_Rank= Rank([AP@10%];[Branch Code]) ForEach([Branch Code]))

and i have created one more variable V_Rnk_bkt based on the V_rank variable ie

V_Rnk_bkt=If([V_Rank] Between(0;50);"0 TO 50";

If([V_Rank] Between(51;100);"51 TO 100";

If([V_Rank] Between(101;150);"101 TO 150";

If([V_Rank] Between(151;200);"151 TO 200";"Others"))))

Now i am not able to do the custom sort on V_Rnk_bkt and when i use this on crosaa tab i am facing multivalue error. so please help me onthis.

Regards

Poonam