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

Nora104 — Tue, 15 Dec 2020 06:27:04 GMT

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?

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

MayilVahanan — Tue, 15 Dec 2020 06:51:51 GMT

Try like below

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