pivot table date

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Table - Date Order

Pivot Table - Date Order

resolvedResolved · High Priority · Version 365

Alan has attended:
Excel Intermediate course
Excel Advanced course

Pivot Table - Date Order

I've created a pivot table however, when I have dates as a column, it is not showing in actual date order - the data seems to be "losing" the year and it simply orders it by month Jan-Dec. However some of the data is, for example, December 2022 but it is showing it almost as December 2023 (as the last month in the table).
Is there a setting somewhere for this?
My table showed it correctly yesterday but not today???

RE: Pivot Table - Date Order

Hello Alan,

Thank you for your question. The first thing you can try is once you have brought the dates into the pivot table, in the Analyse tab, select Ungroup in the Group section. Then select Group Field and select Year and Month. Hopefully, this will group your dates by year and then by month.

If this doesn't work for you, please post in the forum again so that we can find a different solution.

P.s. please make sure that your dates are entered correctly, e.g. 21/01/2022.

Kind regards
Marius Barnard
STL

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Paste with Live Preview in Excel 2010

Did you know you can preview what you are about to paste? Here's how to do it.

Copy what you are about to paste
Position the cursor where you want to paste
Right click to display the shortcut menu
Place the cursor over the Paste Options and this will give you a preview of the what you are about to paste.

View all Excel hints and tips


Server loaded in 0.09 secs.