Forum Discussion
jmc282
Oct 21, 2019Copper Contributor
Pivot Table sorting
Hello - I am trying to sort a pivot table from largest to smallest amount in a "SUM" column. Whenever I go to 'sort' - 'largest by smallest' I only have the option to change the columns to the left, ...
PlaneFun330
Oct 21, 2019Copper Contributor
Try eliminating all but the first of the "informational" fields. In your example, de-select the "Account Name" field.
Now sort by the Value ("SUM") column.
Finally add your informational fields back.
Your data should remain sorted. Unfortunately, if you need to refresh the pivot table because of changes or additions in data, you may need to repeat these steps.
jmc282
Oct 21, 2019Copper Contributor
PlaneFun330 Thank you so much! That worked perfectly.