Calculated Field

11 lessons in order

How to Show Actual Value Not Sum in Excel Pivot Table

Learn how to show actual values instead of sums in Excel PivotTables by creating measures and organizing fields for accurate data display.

Jun 23, 2025

Read article

Excel Pivot Table

How to Edit a Calculated Field in Excel Pivot Table

Learn how to edit calculated fields in Excel PivotTables by adding new fields and modifying existing formulas step by step.

Jun 24, 2025

Read article

Excel Pivot Table

How to Delete Calculated Field in Excel Pivot Table (2 Methods)

Learn how to delete a calculated field in Excel PivotTables manually or by using VBA for quick and efficient cleanup of your data.

Jun 24, 2025

Read article

Excel Pivot Table

How to Use an IF Statement in a Calculated Field of a Pivot Table

Learn how to use an IF statement in a Pivot Table’s calculated field in Excel, including applying conditions to text fields effectively.

Jul 6, 2025

Read article

Excel Pivot Table

Create a Pivot Table Calculated Field That Divides Sum by Count

Learn how to create a Pivot Table calculated field in Excel that divides sum by count using a helper column and a custom formula step-by-step.

Jul 6, 2025

Read article

Excel Pivot Table

How to Calculate Weighted Average in Excel Using Pivot Table

Learn how to calculate weighted average in Excel using a Pivot Table with helper columns and calculated fields in a few simple steps.

Jul 6, 2025

Read article

Excel Pivot Table

How to Do Ranking in Excel Pivot Table (4 Useful Ways)

Learn how to rank data in a Pivot Table using sorting, calculated fields, and RANK functions with dynamic source table updates.

Oct 14, 2025

Read article

Excel Pivot Table