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 - 08 Dec 2006 21:34 GMT
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.
> Hello,
>
[quoted text clipped - 17 lines]
> FIENG Total 119,387.00 179,077.00
> 123,634.00

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