Prev: Microsoft Excel Merge Cells
Next: Reduce balance
From: Nate on 11 Mar 2010 15:30
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
From: Benliaw on 11 Mar 2010 19:59
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
From: Roger Govier on 12 Mar 2010 04:55
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
--
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
 | 
Pages: 1
Prev: Microsoft Excel Merge Cells
Next: Reduce balance