Groupings within PivotTables

  • Thread starter Thread starter Fred
  • Start date Start date
F

Fred

I'm using XL2003 to chart cell phone usage by month. Each month I add data
to a worksheet, then use a pivot table to extract month by month data. I've
then tried to group the months by quarter, which worked fine until there
were about 3000 records in the source database; anything past that yields an
error saying that the data cannot be grouped.

I've also taken a worksheet that IS working properly, grouped by quarter
within the PivTab; when I simply add one line to the middle of the database
list, it again ungroups the table and claims that it cannot be grouped,
though there might only be 1000 records in the source.

Any hints?
 
If there's a blank cell, or cell with text, in the date field, you won't
be able to group the dates.
 
You must log in or register to reply here.

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

Similar Threads

weekday in pivot table 4
grouping dates in a pivot table 1
Pivot Table Grouping 1
pivot table data 2
Grouping in Pivot Tables 2
Pivot Table - Grouping 3
Grouping Dates in a Pivot table for years that are not calendar ye 1
Sales tracking report 4

Back
Top