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