add subtotals in columns in pivot table

  • Thread starter Help Eliminate Auto Theft
  • Start date
H

Help Eliminate Auto Theft

I have a pivot table with three years of various categories of data in rows,
divided into quarters for the years 2005-2007, running horizontally in 12
columns. I would like to insert a new column for the total of the 4 quarters
for each year.
Can someone please give me some guidance?
Thanks in advance.
 
D

dar

This is a function related to the particular field. (assuming yr
field is part of the pivot table) right click on the file and choose
FIELD SETTINGS. in the sub-section titled SUB-TOTALS ensure AUTOMATIC
is clicked (or CUSTOM If you should want a custom calculation instead
of SUM

dar
 
Top