Inside Microsoft Office

Show or hide your PivotTable’s grand totals

Inside Microsoft Office

by Kara Hiltz

You don’t always need totals for both columns and rows. For example, the Grand Total row in the PivotTable shown in Figure A isn’t necessary because you won’t need to know the total of your accounts’ end balances over the first six months. But the Grand Total column is helpful because it tells you the end balance of all three accounts combined for each month.

Figure A: You don’t need the Grand Total row at the[…]


Subscribe to Inside Microsoft Office

(get full access to archives and more)