PIVOT TABLE - GRAND TOTAL COLUMN

  • Thread starter Thread starter SSJ
  • Start date Start date
S

SSJ

Hello,

I am unable to get the the grand total column on the right as shown below. I checked the 'Table Options' and the 'Grand totals for columns' is checked. So I am notsure what else to check.

Thanks
SJ

Data
CUSTOMER WO# Sum of LAB COST Sum of LAB OVHD Sum of MAT COST
FIENG 29599 96,745.00 145,114.00 110,742.00
48804 3,864.00 5,796.00 537.00
49537 - - 3,714.00
49626 18,778.00 28,167.00 8,641.00
FIENG Total 119,387.00 179,077.00 123,634.00
 
You'll see the Grand Totals if you add a field to the Column Area, but
it will total each data field separately.

You could create a Calculated Field, to add the three data fields. Or,
create a new column in the source data, total the fields there, and add
that new field to the pivot table.
 
Back
Top