Pivot Table Variance

N

Nate

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
 
B

Benliaw

Click on the Pivot table.

PivotTable Tools => Options => Formulas => Calculated Field...

Name: Comparison
Formula: = February - January

Click Yes if this is helpful.
 
R

Roger Govier

Hi

No need for calculated fields.
Drag Revenue to the data area a second time.
Double click the field>Options>Show data as>% Difference from>Base
field>Months>Base Item>Previous
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates In Excel 5
Dealing with a Pivot Table (when I don't want to) 0
Power Pivot Variance Column 0
Doughnut Chart linked with the slicer in the pivot table 0
Headings for Sum in Pivot Table. 5
Pivot table and variance calculation 1
Pivot Table Question 1
Pivot Table and Grouping Problem 3

Top