Sometime, after you have made a PivotTable you realize you might want to do some further calculations based on the summary results. For example, After getting the total revenue of a company by each division, and the total number of orders for each division, then you might want to calculate the revenue per order -right in the generated PivotTable. This is where “Calculated Fields” are for.

Take a look at the following tutorial.


Download the Excel File here.