| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula fill - subtracting results of two Pivot Tables?
Hi,
I have two Pivot Tables and would like to subtract the values of one from the other. When I try to go to a blank cell and enter the formula I'm ok but when I try to use the fill function I get the same result in each cell. Any suggestions to fill the formula down the column? Thanks Bruce |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula fill - subtracting results of two Pivot Tables?
You're probably creating a formula with the GetPivotData function, which
may be created when you reference a cell in a pivot table. You can change this setting, or you can type an equal sign, and type the cell reference, instead of clicking on the pivot table cell to reference it. To change the setting, there are instructions here to add the Generate GetPivotData button to your toolbar. Then, use the button to turn this feature on or off: http://www.contextures.com/xlPivot06.html Perkgolf wrote: Hi, I have two Pivot Tables and would like to subtract the values of one from the other. When I try to go to a blank cell and enter the formula I'm ok but when I try to use the fill function I get the same result in each cell. Any suggestions to fill the formula down the column? Thanks Bruce -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula fill - subtracting results of two Pivot Tables?
Thanks Debra
Bruce "Debra Dalgleish" wrote: You're probably creating a formula with the GetPivotData function, which may be created when you reference a cell in a pivot table. You can change this setting, or you can type an equal sign, and type the cell reference, instead of clicking on the pivot table cell to reference it. To change the setting, there are instructions here to add the Generate GetPivotData button to your toolbar. Then, use the button to turn this feature on or off: http://www.contextures.com/xlPivot06.html Perkgolf wrote: Hi, I have two Pivot Tables and would like to subtract the values of one from the other. When I try to go to a blank cell and enter the formula I'm ok but when I try to use the fill function I get the same result in each cell. Any suggestions to fill the formula down the column? Thanks Bruce -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Chart/Sheet comparisons -- adding or subtracting sheets | Excel Discussion (Misc queries) | |||
| formula in pivot tables involving counting text cells | Excel Worksheet Functions | |||
| Pivot tables - Fill In All Rows | Excel Discussion (Misc queries) | |||
| Using value from 2 tables to fill a cell | Excel Discussion (Misc queries) | |||
| How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
Linear Mode
