i have a pivot table that shows the grand total for some columns, but
not for others...
there are no differences in the data layout, yet this happens?
any clues as to why? and how I can get the grand totals to show for
all fields.
thanx
Frank Zhong - 04 Oct 2007 22:09 GMT
in the PivotTable floating toolbar, click PviotTable, then Table Options,
select 'Grand totals for columns' option.