Unable to Group in Pivot Table

J

joshua.rector

I have a data set and have created a pivot table based on the data set. I have a column containing a numeric value in my data set that is set as the Row in my Pivot Table. I would like to group by this column, but for some reason the the Group option on the pivot table is greyed out. Any advice?
 
P

Peter T

I have a data set and have created a pivot table based on the data set. I
have a column containing a numeric value in my data set that is set as the
Row in my Pivot Table. I would like to group by this column, but for some
reason the the Group option on the pivot table is greyed out. Any advice?

Do you mean you have a 'number' as a row or column header in your source
data. If so in a light test I didn't have any problems when said numeric
item is used as a Row item as you describe. Perhaps you upload a file
somewhere that illustrates.

Regards,
Peter T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top