View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Help Eliminate Auto Theft Help Eliminate Auto Theft is offline
external usenet poster
 
Posts: 2
Default add subtotals in columns in pivot table

Please disregard as I found the solution.

"Help Eliminate Auto Theft" wrote:

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.