View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dan dan is offline
external usenet poster
 
Posts: 866
Default create yearly subtotals in pivot table

I have a pivot table with 12 columns (Jan-Dec) repeated for 3 years. This
data is grouped by year-month. I have 5 rows of data for each month of the
three years.
I'd like to create a sub-total column of row data for each year. Can anyone
give me some guidance?
Thanks,
Dan