pivot table grand totals not showing for all columns...

J

J.W. Aldridge

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
 
G

Guest

in the PivotTable floating toolbar, click PviotTable, then Table Options,
select 'Grand totals for columns' option.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Grand Total Issue 3
Pivot Table 1
Pivot Table Totals When Using Pages 1
Re: Differences instead of sums in pivot table 2
pivot tables shows grand totals sometimes, sometimes not...? 3
Pivot grand total 1
Pivot Table Grand Total Placement 2
Referencing a pivot tables Grand Totals Column 1

Top