Prev: I can't see Grand total rows even though the option's switched on
Next: Sum of two groups
From: Roger Govier on 21 Apr 2010 13:46
Hi Rachael

It all depends upon what you have set up as your column Items.
Some things are not additive, and displaying a Grand Total at the end of
the Row would be meaningless.

Can you post a small sample of your source data, and then say what
fields you have allocated to what area of your PT.
--
Regards
Roger Govier

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
 | 
Pages: 1
Prev: I can't see Grand total rows even though the option's switched on
Next: Sum of two groups