+ Reply to Thread
Results 1 to 5 of 5

'Group Field' option grayed out.

  1. #1
    Registered User
    Join Date
    09-07-2012
    Location
    Pasadena, CA
    MS-Off Ver
    Excel 2010
    Posts
    3

    'Group Field' option grayed out.

    I apologize in advance, I am relatively new to Pivot Tables/Charts.

    Please view the sample in the attachment.

    I'm trying to group Distance into ranges for better analysis. Selecting I5, I expect to be able to go to Options/Group group/and select Group Field. However, it is grayed out.

    I suspect it is because my Detail column has text as well as numbers. But I would have thought that I've filtered that out in the Pivot Table so that my data set in the Pivot Table is only numbers.

    Any help us much appreciated. Thanks.
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: 'Group Field' option grayed out.

    You can not group as the Detail field contains a mixture of text and numbers.

    Create a new field in your data to contain the Distance value.

    =IF(ISNUMBER([@Detail]),[@Detail],0)

    You can then use the Distance field and group as required,
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    09-07-2012
    Location
    Pasadena, CA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: 'Group Field' option grayed out.

    Thank you very much for your reply. Your solution works well.

    However can you please verify regarding filtering? It seems it only filters the data for display purposes, but not for calculation purposes, thus allowing the text to mess up my grouping?

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: 'Group Field' option grayed out.

    Yes, if you mean it will still not work if you filter the original field first and then try to group.

  5. #5
    Registered User
    Join Date
    09-07-2012
    Location
    Pasadena, CA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: 'Group Field' option grayed out.

    Thanks Andy! You're the best!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1