| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Pivot Table in Excel 2002
I'm trying to enter a simple formula outside my pivot table that subtracts
the results of 2 separate columns of data. Instead of a formula like B5 - A5, I get a long formula =GETPIVOTDATA(column selections, row selections, etc, etc.) I see what the GETPIVOTDATA formula is trying to do, but in this case I just want the simple B5 - A5. How do I get this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel XP Pivot Table | Excel Discussion (Misc queries) | |||
| How do I expand the column size on a Pivot Table using Excel 97? | Excel Discussion (Misc queries) | |||
| Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) | |||
| pivot table multi line chart | Charts and Charting in Excel | |||
| Password protect cells PivotTable & allow the Pivot Table to refre | Excel Worksheet Functions | |||
Threaded Mode
