| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table and variance calculation | Excel Discussion (Misc queries) | |||
| Pivot Table: Variance formula | Excel Worksheet Functions | |||
| Pivot Table Variance help | Excel Discussion (Misc queries) | |||
| Pivot Table Subtotals/Variance Analysis | Excel Discussion (Misc queries) | |||
| Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) | |||
Hybrid Mode
