Sort sum field in pivot table
 

Hi,

Is there any way to sort a pivot table according to the calculated field? I
know you can sort on other fields by right clicking on the field title
field settings advanced...

However, when I try to do the same for the sum field, the advanced button is
replaced by a "Number" button and I can't seem to sort.

I would like to sort my PivotTable in descending order of sum, not by the
category name.

Any help would be greatly appreciated!

Thanks!