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

Pivot Table unhide/show Grand total column

ResolvedVersion 2007

Fri 19 Mar 2010, 13:55 Delegate 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?

Mon 22 Mar 2010, 12:00 Trainer 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@stl-training.co.uk

Thanks

Stephen

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Viewing Many Worksheets

If there are more worksheets in your workbook than there is room to show all their tabs at the bottom of the screen - Right click on the navigation arrows. A list of all your worksheets is shown. You just click on the one that you want to access. If you have more than 15 worksheets, select in the list and choose your worksheet from hundreds.

View all Excel hints and tips

Pivot Table unhide/show Grand total column

Pivot Table unhide/show Grand total column

RE: Pivot Table unhide/show Grand total column

Excel articles

Excel tip:

Viewing Many Worksheets