Contextures

Pivot Table Subtotal Videos

How to format the data in pivot table subtotals, add multiple subtotals, create custom subtotals, and links to other Excel videos

Date Format in Subtotals

Use slicers in Excel 2010 to filter one or more pivot tables. Quickly see the filtered items, and identify the dependent items in another slicer.

For detailed instructions and to download the sample file, see Pivot Table Subtotals.

Show Multiple Subtotals in Pivot Table

Excel pivot table subtotals are automatically created when you add more fields to Row and Column areas. This video shows how to change summary function, and create multiple subtotals

Custom Subtotals and Calculated Fields

In this short Excel video tutorial, you can see how to create custom subtotals for the inner and outer pivot table fields.

_________________

More Excel Videos

Excel Videos - Index

Mouse Shortcuts

Pivot Table Tips

Names

Paste Special

Search Contextures Sites

 

Free Pivot Table Tools

 

 

Last updated: December 29, 2016 1:22 PM
Contextures RSS Feed