Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts

    Grouping Dates in Months Pivot Tables

    I have set up a pivot table with dates in Col A. I would like to group the dates into months. However, when I select Col A and select group, I get a message "Cannot group that selection"

    I have attached sample data


    Your assistance in this regard is most appreciated


    http://www.mrexcel.com/forum/excel-q...vot-table.html
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Check to make sure the contents of all the cells in that column read as values and not text. When I open it, due to my US settings (mm/dd/yyyy) about half the values are text [The other half are misread when I open it since they are in dd/mm/yyyy format] So I can't tell anything more...

    Steve

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    Hi Steve

    I added an additional column to convert the dates from text and managed to then grouped the dates by month

    Regards

    Howard

Posting Permissions

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