PIVOT TABLE - GRAND TOTAL COLUMN
 

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

PIVOT TABLE - GRAND TOTAL COLUMN
 

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.

SSJ wrote:
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



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html