Pivot Table Variance
Click on the Pivot table.
PivotTable Tools = Options = Formulas = Calculated Field...
Name: Comparison
Formula: = February - January
Click Yes if this is helpful.
"Nate" wrote:
I have a pivot table that shows gross revenue by month. The months are the
column headers. Is it possible to create a field within the pivot table that
shows the variance between January and February's gross revenue? I don't
have access to the source data. Thanks,
Nate
XL2003
|