Thread: I can't see Grand total rows even though the option's switched on
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RachaelE RachaelE is offline
external usenet poster
  
Posts: 1
Default I can't see Grand total rows even though the option's switched on
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
Reply With QuoteReply With Quote