Sorting dates in pivot table

Sundance_Kid

New Member
Joined
Sep 2, 2017
Messages
45
Office Version
  1. 365
Platform
  1. Windows
Hi Folks,

Having an issue sorting dates in the pivot table.

Source data has a date column and cell format for the dates is in the Date category. Date is shown as 30/11/2020 to denote 30th November 2020 or 28/08/2020 to denote 28th August 2020.

In the pivot table I have ungrouped the cells for the date and the date shows as above, however I cannot sort the 15 or so dates in order.
The date is in the Rows section of the pivot table and there are other fields in the rows section to - all preceding the date field.

However when I put the date field to the beginning of all the fields in the Rows section of the pivot table, I can sort the table by date.

But I don't want the date field at the beginning of the pivot table but towards the end, but basically it won't sort the dates in order then.

Any ideas?

TIA
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Watch MrExcel Video

Forum statistics

Threads
1,129,373
Messages
5,635,884
Members
416,886
Latest member
coreyalaurence37

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
Top