View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Gary Rowe Gary Rowe is offline
external usenet poster
 
Posts: 14
Default Totals in Pivot Table

In your pivot table select the company header then on the pivot table toolbar
select pivot table formulas calculated item, select the company field and
then create a formula adding A+B.
Gary

"Rob" wrote:

I am trying to see if you can get the totals for columns to appear right next
to the data they reference. Is this possible? See below.

Hours Dollars
Company A Company B Total Company A Company B Total
Dec 06 8 7 15 100 90
190

instead of
Hours Dollars Hours Total Dollars
Total
Co. A Co.B Co. A Co. B
Dec 06 8 7 100 90 15 190