I can't see Grand total rows even though the option's switched on
in [General]
|
Prev: How do I cancel/delete read only for a worksheet?
Next: I can't see Grand total rows even though the option's switchedon
From: RachaelE on 21 Apr 2010 12:56 Can anyone help ? I am creating a Pivot table in Excel 2007 and want to see Totals for columns and rows. I have checked both boxes in Options / Totals & Filters/Grand Totals and also in Design /Grand Totals / On for Rows & Columns but it is only displaying the Grand Total for columns. What am I doing wrong ? Be really grateful for any ideas. Thanks
From: Don on 21 Apr 2010 14:01
is it due to the way the items are showing? Do they look offset or one in each column? Bring up the Pivot Table Field List and in the Row Lables section left click once on an item and bring up the Field Settings then you should see a tab for Subtotals and Filters and make sure it says Automatic. Then click on the Layout and Print and make sure you check Show item labels in tabular form. If this does not work, write back "RachaelE" wrote: > Can anyone help ? > I am creating a Pivot table in Excel 2007 and want to see Totals for columns > and rows. > I have checked both boxes in Options / Totals & Filters/Grand Totals and > also in Design /Grand Totals / On for Rows & Columns but it is only > displaying the Grand Total for columns. > > What am I doing wrong ? Be really grateful for any ideas. Thanks |