Pivot table: How do I make a monthly breakdown of daily data?
However, if your source data includes dates over more than one year,
then you will also need to group by MONTH *and* YEAR, by holding CTRL
down as you select them both. If you don't do this all data for each
month will be aggregated, so for example; January 2008 and January 2009
data will be aggregated into just one 'January' total unless you also
group by YEAR,
Jay
--
David wrote:
if you are using office 07- have date in date format- not text- click on a
date in the pivot table- click group and you should automaticly get an option
to group by month
|