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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Customize an Excel Slicer   Excel Slicers are very boring looking and there are only 14 different Slicer Styles to choose from, ranging from Light to Dark and with a few colors to choose from. What if you wanted to create your own Slicer using your creative mind with super cool colors and f...
Free Pivot Table Webinar Hey there, I have been having a huge response to this highly acclaimed Pivot Table webinar and will continue to give these lessons in to the new year!  If a date is not suitable for you, you can always come back to the Registration link below on a future date.  Happy Pivot...
Excel Chart Line Styles There are several line styles that you can include with your Excel Line Chart to make it stand out or tell a story. You can adjust the WIDTH of the line to make it as thin or thick as you like. You can make your line chart have a COMPOUND or DASH effect. You can also add...
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...