• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sorting dates in Pivot table

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
 

Attachments

  • PIvot table query.xls
    429.5 KB · Views: 2
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.
 

Attachments

  • PIvot table query.xls
    424.5 KB · Views: 5
Back
Top