How to use rank function to sort values from small to large in pivot table

[Nora104]

I want to add a rank column to the front so that it will start from small to large by index B：

But I use the formula:=aggr(rank(sum(indexB)),Code)

But the result is the below, the values are sorted from largest to smallest:

How can I write the formula to sort from small to large?

[MayilVahanan · Accepted solution]

HI @Nora104 

Try like below

=aggr(rank(-sum(indexB)),Code)