How Do I Create Grand Totals for Rows in a Pivot Table?

ET Hug

Board Regular
Joined
Jun 3, 2005
Messages
111
Hello Everyone,

I'm hoping this is an easy question to answer. I've created a pivot table. so far so good.

I have grand totals for my columns, but can't seem to get grand totals for my rows (adding all the data from left to right).

To try and resolve the problem I tried going to Table Options and checkmarking Grand Totals for Rows but this doesn't work - nothing comes up. Are there limitations on when a pivot table can create this calculation? Am I doing something wrong?

Any help is appreciated
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

texasalynn

Well-known Member
Joined
May 19, 2002
Messages
8,458
when you create your pivot table are you using Sum on the data section?
 

ET Hug

Board Regular
Joined
Jun 3, 2005
Messages
111
Hi Texasalyn,

Yes. I'm using sum on all my data selections, and even formatted them to be shown as numbers.

I've been looking for the past hour on this site and the www and I keep running into things that say that all I have to do is checkmark the box titled "Grand Totals for Rows". I must be doing something wrong.
 

ET Hug

Board Regular
Joined
Jun 3, 2005
Messages
111
I think I'm having this problem because I didn't drop anything under columns in the Pivot Table layout screen. I've clicked and dragged data into "rows" and into "data", but not columns.
 

texasalynn

Well-known Member
Joined
May 19, 2002
Messages
8,458
you are correct. WIthout something in the column then there is nothing to total left to right
 

Watch MrExcel Video

Forum statistics

Threads
1,118,763
Messages
5,574,096
Members
412,567
Latest member
mm1
Top