Show Subtotals at Bottom of Pivot Field

When you add fields to the Row Labels area of a new pivot table, subtotals are automatically shown at the top of each group of items, for the outer fields.

subtotalstop01

You can turn the subtotals off, or move them to the bottom of the group, if you prefer.

Watch the Video

To see how to add subtotals, and move them, you can watch this short video tutorial. You’ll also see how the pivot table’s report layout affect the subtotals in the Row Labels area.

For written instructions, and more details on working with subtotals, please visit my Contextures website: Pivot Table Subtotals

_________________________

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.