Calculate Data in a PivotTable in Excel

This guide provides a practical overview of Calculate Data in a PivotTable, including its main features, benefits, limitations, and important considerations.

Creating statistical reports using PivotTable mainly through numbers: summing up quantity, highest sales, lowest. Therefore, the calculation in PivotTable is based on calculating numbers.

The example has the following data table:

Create a PivotTable report with the above data table reported:

1. Showing data in the report by month.

Step 1: Right-click on any day -> Group:

Step 2: The Group dialog box appears, click Months -> OK:

Step 3: After clicking OK -> report is synthesized by month:

2. Convert the calculation to a percentage.

For example, convert the value in the sales column to a percentage.

- Right-click on any value in the Sum of revenue column -> Show Values As ->% of Column Total:

- After selecting the data table, automatically update according to the percentage:

3. Determine the maximum, minimum value, or any calculation in a PivotTable.

For example, find the salesperson with the highest sales.

- Right-click any revenue value in the Sum Of sales column -> Summarize Values By -> Max (or you can optionally choose any calculation such as Average, Min, Product. depending on requirements):

- After choosing the report, automatically update and sort data by revenue and from the report, you can immediately see the highest revenue earner:

Similarly you can do with each other.

Above are detailed instructions and specific examples to help you calculate data in a PivotTable so that you can create multiple reports quickly and accurately for your work.

Good luck!