You should group by both month and year if you don't want this year's July
to merge with last year's. You can group by quarter as well, and show
quarter or month depending on what you are interested in.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Del Cotter" wrote in message
...
On Wed, 22 Aug 2007, in microsoft.public.excel.charting,
That70sHeidi said:
I've played with the sorting and the filtering, and so far the Pivot table
is
working well, I just have to figure out which piece of data goes where (I
used to be able to do this fairly well... so much for the riding a bike
analogy!).

The last piece that's eluding me is comparing apples and oranges - Value
Big
/monthly/ totals.

There is a way to instruct Pivot Tables and Charts to group monthly even
when your data is in date form; if you right-click on the Date in the
Pivot Table, Select "Group and Outline.. Group" and select "Months" in the
list, it groups all the dates together by month.

That way you don't have to create a special column for Month.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.