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.
Leave a Reply
You must be logged in to post a comment.