When you insert an Excel Pivot Table and drop a field in the Row/Column Labels you will automatically get a Grand Total.

How about if you want to remove this Grand Total or show it only for a row or column?

Well you have that flexibility and this is how…

DOWNLOAD EXCEL WORKBOOK

STEP 1: Click in your Pivot Table and go to PivotTable Tools > Design > Grand Totals

STEP 2: Choose any of the options below:

off for rows & columns

Off for rows & columns pivot

On for rows & columns

On for rows & columns pivot

on for rows

on for rows pivot

on for columns

on for columns pivot

SHORTCUT TIP: You can also remove a Grand Total by Right Clicking on the Grand Total heading and choosing Remove Grand Total

remove grand total shortcut

Insert Grand Totals

HELPFUL RESOURCE:

728x90

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Microsoft Excel Pivot Tables Online Tutorial Pivot Tables are one of the most powerful features of Microsoft Excel. They allow you to analyze more than 1 million rows of data with just a few mouse clicks, show the results in an easy to read table, highlight key information to management and include graphs for your monthly p...
Sort by Largest or Smallest With Excel Pivot Table... There are countless times when I had my Pivot Table all setup, but I was not really happy with how the data was sorted. The cool thing with Excel Pivot Tables, is it allows me to sort virtually anywhere!Let us start off with this Excel Pivot Table showing the Sum of SALES for...
50 Things You Can Do With Excel Pivot Tables Pivot Tables in Excel are one of the most powerful features within Microsoft Excel.   A Pivot Table allows you to analyze more than 1 million rows of data with just a few mouse clicks, show the results in an easy to read table, "pivot"/change the report layout with the ease of dr...
Format Error Values in a Pivot Table Whenever you do a calculation in an Excel Pivot Table you may get an error value like a #DIV/0!This looks ugly when you are presenting important information.  Luckily you can override this with a custom value or text.To activate this you need to Right Click in any Value i...