Grand Total for Rows not Working in a Pivot Table


T

Tiffany McKerahan

Hi, I'm working with a Pivot Table in Excel 2007 and for some reason I
can't get the Grand Total for Rows to appear. I tried the usual step
of Pivot Table Tools > Design > Grand Totals > On for Rows but nothing
happens. The table doesn't appear any different from ones I've
created before:

Year Product 1 Product 2
2009 200 500
2008 150 400

The Grand Totals do work for the columns but not the rows. Any
suggestions?

Thanks so much!
Tiffany
 
Ad

Advertisements

R

Roger Govier

Hi Tiffany

Do you have Year as a Row Label, Product as a Column Label and your data as
Values?
If so, then you should be able to to show a grand total for Rows.

If you are still having problems and want to send me a copy of your file, I
will take a look and see if i can figure what is wrong.
To mail direct
roger at technology4u dot co dot uk
Change the at and dot to make valid email address.

--
Regards
Roger Govier

Tiffany McKerahan said:
Hi, I'm working with a Pivot Table in Excel 2007 and for some reason I
can't get the Grand Total for Rows to appear. I tried the usual step
of Pivot Table Tools > Design > Grand Totals > On for Rows but nothing
happens. The table doesn't appear any different from ones I've
created before:

Year Product 1 Product 2
2009 200 500
2008 150 400

The Grand Totals do work for the columns but not the rows. Any
suggestions?

Thanks so much!
Tiffany

__________ Information from ESET Smart Security, version of virus
signature database 4798 (20100122) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4798 (20100122) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 

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

Top