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