ExcelBanter - create yearly subtotals in pivot table

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - create yearly subtotals in pivot table (https://www.excelbanter.com/excel-worksheet-functions/174064-create-yearly-subtotals-pivot-table.html)

dan

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

All times are GMT +1. The time now is 04:46 PM.