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
    Nanaimo, BC, Canada
    Blog Entries
    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: -||- Blog: -||- 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.
    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