Pivot Table Calculated Fields in Excel

= Revenue / Units

A calculated field creates a new column in your Pivot Table using existing fields. Revenue / Units gives you the average revenue per unit, calculated at the aggregation level of your Pivot Table layout.

1. Go to PivotTable Analyze > Fields, Items & Sets > Calculated Field
2. Name the field (e.g., "Revenue Per Unit")
3. Formula references existing field names, not cell references
4. The calculation applies at whatever grouping level your Pivot Table uses
5. The result appears as a new Value field in the Pivot Table

• Calculated fields operate on sums, not individual rows — this can produce different results than row-level calculations
• Division by zero when a group has 0 units — no built-in error handling in calculated fields
• You can't use worksheet functions like IF or VLOOKUP in calculated fields
• For row-level calculations, add the formula to your source data instead