Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to Group in Pivot Table
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?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to Group in Pivot Table
wrote in message 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to make a pivot table in sheet2 | Excel Discussion (Misc queries) | |||
Unable to update data from pivot table | Excel Worksheet Functions | |||
how to group a pivot table | Excel Discussion (Misc queries) | |||
Unable to read error in a pivot table | Excel Discussion (Misc queries) | |||
Pivot Tables: Unable to Group and Show Detail | Excel Discussion (Misc queries) |