Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Table unhide/show Grand total column

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Pivot Table unhide/show Grand total column

Resolved · High Priority · Version 2007

Reply Fri 19 Mar 2010, 13:55Delegate Sebrena said...

Sebrena has attended:
Excel Advanced course

Pivot Table unhide/show Grand total column

Hi

I've created Pivot Table and I am unable to view the rows Grand total. I've tried going to Options - Totals an Filters, selected both Row and column filter and it still not appearing on the pivot table. (Totals for column appears but not rows)

Any idea how to show the Grand total?

For upcoming training course dates see: Pricing & availability

Reply Mon 22 Mar 2010, 12:00Trainer Stephen said...

RE: Pivot Table unhide/show Grand total column

Hi Sebrena

Thanks for your question

This is slightly puzzling and hard to solve without seeing the file.

Could you email me the workbook, so i can investigate further.

My email address is sw

Thanks

Stephen

Excel articles

· The Importance of Data Backups
· Creating Charts with Excel
· Mastering Page Layout In Excel
· Identifying Suitable Candidates For VBA For Excel Training
· Data Basics Using Excel

Please browse our web site to find out more about
excel classes and other Microsoft training courses.

Excel tip:

Showing all menu items

If you go into a pull down menu you usally find that you get a selection of items(this is the default) or sometimes everything. If you only get a selectiopn you have to go to the double arrows at the bottom of the menu and click it to get all of the hidden items.
To turn this off so that you always get everything, go to Tools / Customize / Options Tab / "Always show full menus". Make sure there is a tick in the box and you will always have every item.

View all Excel hints and tips