How to format the data in pivot table subtotals, add multiple subtotals, create custom subtotals, and links to other Excel videos
When you add subtotals to a pivot table date field, there might be a different date format in the subtotals, compared to the rest of the dates in the field.
Watch thisshort video to see how to see why this happens, and see how to avoid the problem of different formats.
For detailed instructions and to download the sample file, see Pivot Table Subtotals.
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
In this short Excel video tutorial, you can see how to create custom subtotals for the inner and outer pivot table fields.
Last updated: March 7, 2023 11:02 AM