rank and Order by

[#1]

Hello,every body here:

I used a pivot table to get a display like my attached jpg chart.

NO.N means in the period of time (may be thisweek or lastweek),each company (may be COMP.A,COMP.B,COMP.C) ordered by their sales volumn descend

I used aggr(rank()) as my dimension ,but it still didn't work.

Can anybody help me ?