Skip to main content

Excel Tips: Insert > PivotTable and PivotChart

Author: Kelly Last Modified: 2020-03-11


Data Source of PivotTable

How to combine multiple sheets into a pivot table in Excel?

How to consolidate multiple ranges into one pivot table in Excel?

How to create a Pivot Table from Text file in Excel?

How to update pivot table range in Excel?

Add or Remove Fields

How to add calculated field to pivot table?

How to add multiple fields into pivot table?

How to remove calculated field from pivot table?

Grand Total or Subtotal

How to add percentage of grand total/subtotal column in an Excel Pivot Table?

How to display grand total at top in pivot table?

How to hide grand total in an Excel pivot table?

How to hide subtotals in pivot table?

How to show grand total as percentage in Excel PivotTable?

How to show multiple grand totals in pivot table?