View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Totals in Pivot Table

As a guess your source data is not set up correctly to do that... You
probably have

Company Hours Dollars
A 10 100
B 20 300

Instead of
Company Type Amount
A Hours 10
A Dollars 100
B Hours 20
B Dollars 300

As your data stands it will be an uphill battle to get the data re-organized
as you want it...
--
HTH...

Jim Thomlinson


"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