sort number

[#1]

I have a straight table .
This results in the table below:

rank	rank2	store	Products	color	Qty
?	?	?	?	?	90
1	1	Cat2	Pdt2	7	18
1	1	Cat2	Pdt4	9	10
1	1	Cat2	Pdt3	8	9
1	1	Cat2	Pdt1	5	6
2	1	Cat3	Pdt4	9	10
2	1	Cat3	Pdt3	8	9
2	1	Cat3	Pdt2	7	8
2	1	Cat3	Pdt1	5	6
3	1	Cat1	Pdt4	4	5
3	1	Cat1	Pdt3	3	4
3	1	Cat1	Pdt2	2	3
3	1	Cat1	Pdt1	1	2

I want to show three row for store is cat2 and cat1 and cat3.
I have created an expression using rowno() or rowno(total) but it didn't work
i use calcuate demension =aggr(rank(sum(Qty)),store,Products,color) but it only show 1
i want to show 1,2,3,4

i want to show the result below

rank	rank2	store	Products	color	Qty
?	?	?	?	?	90
1	1	Cat2	Pdt2	7	18
1	2	Cat2	Pdt4	9	10
1	3	Cat2	Pdt3	8	9
1	4	Cat2	Pdt1	5	6
2	1	Cat3	Pdt4	9	10
2	2	Cat3	Pdt3	8	9
2	3	Cat3	Pdt2	7	8
2	4	Cat3	Pdt1	5	6
3	1	Cat1	Pdt4	4	5
3	2	Cat1	Pdt3	3	4
3	3	Cat1	Pdt2	2	3
3	4	Cat1	Pdt1	1	2

Thanks in ADVANCE!

[renjithpl]

if i understood your question,

in Rank2 if color is one of your field then you can use below

= Rank(color)

Regards

Ranjit

[rwunderlich]

It looks like you want to rank within store so the expression would be:

=aggr(rank(sum(Qty)),store)

-Rob

[#4]

Thanking you for your reply. but i want rank qty by store

[#5]

Thanking you for your reply .rob wunderlich very much thanks for you

but =aggr(rank(sum(Qty)),store) only show rank

i want show rank2

rank	rank2	store	Products	color	Qty
?	?	?	?	?	90
1	1	Cat2	Pdt2	7	18
1	2	Cat2	Pdt4	9	18
1	3	Cat2	Pdt3	8	18
1	4	Cat2	Pdt1	5	18
2	1	Cat3	Pdt4	9	10
2	2	Cat3	Pdt3	8	9
2	3	Cat3	Pdt2	7	8
2	4	Cat3	Pdt1	5	6
3	1	Cat1	Pdt4	4	5
3	2	Cat1	Pdt3	3	4
3	3	Cat1	Pdt2	2	3
3	4	Cat1	Pdt1	1	2