When you create a Pivot Table that has multiple fields in the Row Labels, Excel will automatically add a Subtotal to the top of the Group.

What about if you want to change the Subtotals to show at the bottom of the Group or take the Subtotals out all together?

Well you have that flexibility when you are dealing with Subtotals, here is how:

DOWNLOAD EXCEL WORKBOOK

STEP 1: Enter at least two Fields in the Row Labels

ROW LABELS

STEP 2: Click in your Pivot Table and go to PivotTable Tools > Design > Subtotals

STEP 3: You can choose either of the three options:

DO NOT SHOW SUBTOTALS

DO NOT SHOW SUBTOTALS PIVOT

SHOW SUBTOTALS AT BOTTOM OF GROUP

SHOW SUBTOTALS AT BOTTOM OF GROUP PIVOT

SHOW ALL SUBTOTALS AT TO OF GROUP

SHOW ALL SUBTOTALS AT TOP OF GROUP PIVOT

Insert Subtotals

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

How To Fix Pivot Table Empty Cells I am sure that you have come across a Pivot Table which has empty cell values and thought "What the hell is happening here?"This is because your data source has blank cells for certain items, which happens from time to time.This can be fixed in your Pivot Table and you ca...
Pivot Charts & Slicers In a previous post I showed you how to Insert a Pivot Chart.  Now we will take this concept once step further and insert a Slicer.  The cool thing about this is that the Slicer will control both the Pivot Table and the Pivot Chart.See how you can start creating some awesome i...
Icon Sets In A Pivot Table An Icon Set is a Conditional Formatting icon/graphic that you can include in your cells or Pivot Tables.The icon will depend on the cell´s value so you can highlight key variances or trends.  There are a few icon sets that you can include, like:DIRECTIONAL (Change in valu...
Conditionally Format a Pivot Table With Data Bars Data Bars are a new Conditional Formatting feature in Excel 2010 and they add a colored bar to your values.The length of the data bar represents the value in the cell.  A longer bar represents a higher value.You have a Gradient Fill or a Solid Fill to choose from as well ...