Pivot Table
Learn how a pivot table groups and summarizes without formulas, which defaults it applies silently, and why it can show stale numbers.
-
-
Calculated Field
Learn how a calculated field computes from aggregated values rather than individual rows, and why that distinction changes the number it returns.