Ranks for Dimensions for two levels

[#1]

Hi All,

I am new to QlikView. I am facinga problem to generate a ranks for two leveled dimesions .Hers is the Example I want to generate a rank to the GROUP based on the Total Sum w.r.t the Group. Reqeust you all to help me on this

Group	Month	Sum	Rank on Sum	Ranks For Groups based on Total Sum
A	1	17	2	2
A	4	16	3
A	7	11	4
A	8	20	1
A	Total	64	-	-
B	2	9	3	4
B	3	22	1
B	5	10	2
B	6	5	4
B	Total	46	-	-
D	1	21	1	1
D	2	18	2
D	5	15	3
D	8	12	4
D	Total	66	-	-
E	3	10	3	3
E	4	21	1
E	6	11	2
E	7	6	4
E	Total	48	-	-

[anbu1984 · Accepted solution]

Aggr(Rank(Sum(Sum)),Group)

[#3]

Hi Anbu,

Thanks you very much ..!!! It's helpful for me..!!! Thanks for your quick response.