Pivot Table Variance
 

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

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

Pivot Table Variance
 

Hi

No need for calculated fields.
Drag Revenue to the data area a second time.
Double click the fieldOptionsShow data as% Difference fromBase
fieldMonthsBase ItemPrevious
--
Regards
Roger Govier

Benliaw wrote:
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