Thread: Pivot tables
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Timmons Sean Timmons is offline
external usenet poster
  
Posts: 1,696
Default Pivot tables
right-Click on a data, go to Group and OutlineGroup. Select Months AND Years.

"patches" wrote:

i have a pivot table of dates (mm/dd/yyyy) and $ amounts and need to sum up
the total amounts by month and year. How do i do this?
Reply With QuoteReply With Quote