Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Pivot table doesn't group months & years like a table filter

  1. #1
    New Member
    Join Date
    Jun 2017
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Pivot table doesn't group months & years like a table filter

    Hello all,

    I don't know if this has always been the case but in Excel 2010 the date as a pivot filter doesn't group the months and year like in a table filter. The data format is correct. Is there a way to make it happen?


    Thanks

  2. #2
    Board Regular
    Join Date
    Sep 2012
    Location
    Melbourne Australia
    Posts
    1,534
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot table doesn't group months & years like a table filter

    ive had the same issue in the past. What I did to resolve this is add two columns and in the first column, I used = Text(Date reference, "YYYY") and the other =Text(Date Reference, "MM").
    This returned the value of the year and the month in two columns. Make sure to add the headings. Then when you want to sort the columns by dates, choose year then month in the pivot table.

    Hope that helps.
    Write a man a macro he is happy for the day....teach a man to write a macro, he'll be happy forever!

  3. #3
    New Member
    Join Date
    Jun 2017
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot table doesn't group months & years like a table filter

    Thanks for your help dermie_72. I used a similar format to that previously. All good. Thanks

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
This website uses cookies
We use cookies to store session information to facilitate remembering your login information, to allow you to save website preferences, to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners.
     


DMCA.com