Sorting Pivot Tables

Davidns

Board Regular
Joined
May 20, 2011
Messages
136
Office Version
  1. 365
Platform
  1. Windows
I am noticing strange behavior in one of my Pivot Tables. The columns are called Amount, My Fee, and My % and are shown by month, and subtotaled by Year. When I sort one of the columns for a given month, it works fine. And when I sort a column in the Totals section, it also works fine. However, when I attempt to sort a column in the subtotals section (shown in grey in the table), it seems to calculate for a moment, but then doesn't update the sort correctly.
I have another nearly identical table wherein there is only one column (Amount) and this table sorts just fine, whether its for a particular month, Year, or Total.

The only workaround seems to be to collapse the year, then to do the sort. But, as soon as i expand the year again, the sort reverts back to the order previously shown.

I am a bit stumped and hoping I described the issue clearly enough. Any suggestions?
Thanks!
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Forum statistics

Threads
1,213,549
Messages
6,114,264
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top