One of the best ways to become an advanced pivot table user and use Excel for data analysis is by using calculated items and calculated fields in a pivot table.

Learn about the calculation methods that are available, how calculations are affected by the type of source data, and how to use formulas in PivotTables and PivotCharts.

By default, Excel summarizes your data by either summing or counting the items. To change the type of calculation that you want to use, execute the following steps.

Jul 15, 2025 · Adding a calculated field in a pivot table helps you perform custom calculations using your existing data set. Instead of changing the original data, you can create new fields …

Click anywhere in the dataset. Go to Insert –> Tables –> Pivot Table. In the Create Pivot Table dialog box, the default options work fine in most of the cases. Here are a couple of things to …

Jul 23, 2025 · Learn how to add, modify, and delete calculated fields in Excel Pivot Tables.

5 days ago · Learn how to create a calculated field in an Excel Pivot Table using column values with clear, step-by-step instructions.

Sep 13, 2025 · This short video shows the steps to create custom formulas in Excel pivot table with calculated fields and calculated items. If you aren't sure which custom calculation type to …

In the example shown, a calculated field called "Unit Price" has been created with a formula that divides Sales by Quantity. The pivot table displays the calculated unit price for each product in …

Discover how to create pivot table formulas in Excel with this clear, step-by-step guide. Enhance your data analysis skills effectively.