View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jason[_14_] Jason[_14_] is offline
external usenet poster
 
Posts: 21
Default 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