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

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