Sorting dates in Pivot table

[Ecel Dumbo]

Dear friends,

Please find attached sheet

I would need to create two pivot table with the below column headings

Pivot table 1

Column heading- Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16


Pivot table 2

Column heading 2015 2015 TOTAL 2016
Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16


I tired converting my raw date column to DATE(YEAR(B#),MONTH(B#),1), but it is not getting sorted out in the above order

Please advise steps

 

[Chihiro]

Right click on any of the column headers. Select "Ungroup"

This will turn it into regular date format instead of it being grouped by month.

Then right click and "Group by" years.

See attached.

 

[Ecel Dumbo]

THank you very much Chihiro