View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David David is offline
external usenet poster
 
Posts: 1,560
Default Pivot table: How do I make a monthly breakdown of daily data?

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
--
HTH

"Metro" wrote:

I have my data organized as date in column A, amount in column B and category
in column C, e.g. 3. Aug 2009 spent $ 200 on clothing and 4. Aug 2009 spent
$50 on restaurant.
I would like to keep track of montly spending on each category and the total
of each month.
My problem is that the date dimension doesn't seem to be possible to group
to a higher level than on the actual date from the data level.
How do I do it?