Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Senior Member
 
Posts: 105
Default Sorting dates in Pivto 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 working

PLease advise
Attached Files
File Type: zip PIvot table query.zip (51.5 KB, 27 views)
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,872
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sorting dates in a pivot table Mike Excel Discussion (Misc queries) 1 October 29th 09 05:49 PM
sorting dates Tom Excel Programming 6 September 2nd 09 02:14 AM
sorting dates tommy Excel Discussion (Misc queries) 5 January 12th 09 01:52 AM
Sorting Dates Pammy Excel Discussion (Misc queries) 2 April 24th 08 08:50 PM
Sorting dates Heather Excel Worksheet Functions 1 June 23rd 05 02:55 AM


All times are GMT +1. The time now is 10:36 PM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"