Sort Pivot table with multiple rows
I have a pivot table in which I selected 2 fields as Rows & dollar amounts in Values
I cannot find a way to sort by descending order of dollar amount for 1st field of Rows without messing up the output sheet
Here is the pivot setup:
Here is the output:
Would you be able to help me ?
Ping @Genevieve P. :)