Pivot Table

[Marion]

I have a large amount of data (7000 rows) which I am
putting in a PivotTable to analyse. One column is a date
column which I would like to group,(by month, quarter,
year) but because many of the dates are different they do
not all fit onto the PivotTable display. I get the
message "PivotTable will not fit on sheet. Show as much
as possible". I then find that I can not group the
data. Is it because all the data is not displayed? I
always get the message - can not group that selection.
There are no gaps in the dates and I have sorted them
into date order.

Is there any way I can get round this problem? Any
assistance gratefully received.

 

[Dave Peterson]

Maybe you can use a helper column of cells:

If your date is in column A, then something like this would reduce the number of
distinct dates (and group them by month):

=date(year(a2),month(a2),1)

Format the column as "mmm-yyyy" (or whatever you like).

 

[Debra Dalgleish]

Or, you may be able to start with the Date in the Row area.
Group the dates there, then drag the Year/Month buttons to Column area