Results 1 to 10 of 10

Thread: How to group the month

  1. #1

    How to group the month



    Register for a FREE account, and/
    or Log in to avoid these ads!

    How to group the months by year as the attached.
    Click image for larger version. 

Name:	group.png 
Views:	45 
Size:	68.2 KB 
ID:	920

  2. #2
    Is it only available in PowerPivot but not in Pivot Table?

  3. #3
    It is available to group by months in a normal pivot table.

  4. #4
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,274
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Once you have your dates set up as column labels in a PivotTable, right click one of the dates and choose Group --> Months --> OK
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  5. #5
    How can I attach my file here?

  6. #6
    Attached the sample file. Anyone can help?
    Attached Files Attached Files

  7. #7
    You need to re-order your data
    Attached Files Attached Files

  8. #8
    Quote Originally Posted by Bob Phillips View Post
    You need to re-order your data
    Your suggestion is changing the source data formation. But I cannot change it and I only want to connect the original source excel file as external data.
    Copying to local table then modify the data is impossible for my case.

  9. #9
    You are going to have to change it somehow, you have no choice. Change it or give up.

  10. #10
    Excel 2010, Table, PivotTable
    Re-normalize with aux PT or SQL in PowerPivot.
    http://58918aa17d4002474361-7ac2b7ee...05_14_13a.xlsx
    If you get *.zip, don't unzip, just rename *.xlsx

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •