Pivot Tables

  • Thread starter Thread starter Fiona
  • Start date Start date
F

Fiona

Monthly dump info from Access into Excel and then do a
pivot table. I am able to refresh the data in the pivot
table from the raw data fine, but I can't group on the
Date field. The raw data has each day in the month and I
group it into a month. When I try to group the Date
field I get the error "Cannot group that selection." Any
help would be appreciated. Thanks
 
The dates have to be numeric, that way you will get the option of grouping
by month,
week etc. If they are dates and look numeric as in 12/15/03 or similar
depending on the region, select an empty
cell, copy it, select the imported dates in the table and do edit>paste
special and check add
Now try again..
 
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

Pivot ungrouping on refresh? 3
pivot table data 2
Group in Multiple Pivot table 1
Pivot table subtotals 2
Grouping daily transactions in a pivot table by month - CANNOT GROUPTHAT SELECTION ERROR 1
Pivot Table Refresh not working properly 1
grouping multiple tables Excel 2007 3
Value filter missing in pivot table 3

Back
Top