ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sorting dates in Pivto table (https://www.excelbanter.com/excel-discussion-misc-queries/453064-sorting-dates-pivto-table.html)

Excel Dumbo

Sorting dates in Pivto table
 
1 Attachment(s)
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 working

PLease advise

Claus Busch

Sorting dates in Pivto table
 
Hi Joseph,

Am Mon, 16 Jan 2017 21:30:44 +0000 schrieb Excel Dumbo:

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


have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgYcfKN__urp0okmH6Q


Regards
Claus B.
--
Windows10
Office 2016


All times are GMT +1. The time now is 02:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com