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.
Bookmarks