grouping dates in pivot table

  • Thread starter Thread starter Charles Maronski
  • Start date Start date
C

Charles Maronski

I have an outstanding checklist which contains two accounts (account 2110
and 2189) I have created a pivot table using the date of the check on the
left, the account on top and the amounts as the data. Example

Account 2110 2189
Date
7/3/04 105 176
7/6/04 116 218
8/3/04 786 197
8/7/04 214 767

I am trying to group the dates so it will read total amount of outstanding
checks for the month. Example:

Account 2110 2189
Date
July '04 221 394
Aug 04 1000 964

When I highlight the word "Date" to group by month, I get a message that
says "Cannot Group this data"

What is the fastest way I can group by month?
 
Are your dates really dates? They're not just text typed into the cell to look
like dates. (You can check with a formula:

=isnumber(a2)
and copy down
If all of them returns TRUE, then they are dates.

If you have empty cells in your date range, then this would be a problem, too.

If you don't have gaps in your range, you could use just one formula:
=counta(a2:a999)=count(a2:a999)
(adjust the range to match)

If that returns True, then they are dates.
 
Dave,

Thank you very much. I had empty cells in the date range. I was highlighting
the entire columns which gave me the empty cells. When I highlighted just
the data I needed, I was able to group by the month. Thanks again for the
help.
 
Back
Top