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
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,023
Messages
5,834,996
Members
430,331
Latest member
Syed Yasir Hannan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top