Pivot Table - Sorting MMM-YY

[DaPain]

Hi,

I have a table in the following format:

DateInserted​	IdentityNumber​	TeamName​	MMYY​
21/12/2022​	0101040504	Team A	Dec-22​
10/05/2022​	0101590849	Team A	May-22​
07/06/2022​	0101632916	Team A	Jun-22​
06/06/2022​	0101750412	Team Z	Jun-22​
25/10/2022​	0101770383	Team B	Oct-22​
22/12/2022​	0101830297	Team E	Dec-22​
14/11/2022​	0101851162	Team B	Nov-22​
10/01/2022​	0101852347	Team E	Jan-22​
07/06/2022​	0101889976	Team A	Jun-22​

The DateInserted is in a date format. The MMYY column is inserted in from the first column using this formula:

=DATE(YEAR(A2),MONTH(A2),1)

and converting it to the date format (MMM-YY)

When I create a Pivot Table then it comes out like this:

What I want is the column headers should be in the format of MMM-YY and sorted as months too.
Like Jan 22, Feb 22..........Jan 23, Feb 23 etc.,


I don't want to use the =TEXT(A2,"mmm-yy") formula, as when i sort this in the pivot table, the dates are recognised as text and will be sorted into alphabetical order, not date order.

Thanks in advance.

 

[DaPain]

I managed it by 'Data Model' options, adding pre-formatted 'Calendar' Table into the model. End Result:

This youtube link was helpful: Properly Handling Date Grouping in Excel Pivot Tables (Change Grouping, Get All dates)