Sorting dates in pivot table

Sundance_Kid

New Member
Joined
Sep 2, 2017
Messages
44
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
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Watch MrExcel Video

Forum statistics

Threads
1,127,140
Messages
5,622,949
Members
415,942
Latest member
Data Midwife

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