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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

First Pivot Table 4
Create subtotal column in pivot table 1
can i add subtotals to subtotals in a pivot table? 1
Rank in Pivot Table 3
Changing Date for Pivot Table Result 2
multiple subtotals in pivot table 1
Count of Non-Zero pivot table entries 1
create calculated field in pivot table 2

Top