PivotTable: Calculated Fields

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.


Posted

in

, , , ,

by

Tags:

Comments

Leave a Reply