Calculated Fields and PivotCharts
A calculated field is a new column of the PivotTable made from others, for example profit = revenue minus cost, or margin = profit divided by revenue. Ratios need care: compute the total profit divided by total revenue for each group, not the average of row margins.
A PivotChart draws a chart from the PivotTable (PivotTable Analyze > PivotChart) and updates with it, so one click gives the picture of the summary.
Exampleexcel
Quick check
How should an overall margin be calculated?
Your turn: write the code
Add Profit (revenue minus cost) in D2:D3 and the margin as a decimal rounded to 2 places in E2:E3.
Finish the quick check (and any code exercise) to complete this lesson, or mark it done yourself.
Tip: use the left and right arrow keys to move between lessons.