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
|