| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculations between pivot tables
I'm using XL2003. Two PTs are side by side in the same worksheet with a
blank column between them. I want to calculate the difference between two cells containing data in the two PTs located in the same row. The calculation is being performed in the blank cell, but same row, between the two PTs. When I enter = then click one PT cell, then press "-" (minus), it fills with "Get PivotTable Data...", with a long string of reference data that covers up the other PT cell making it impossible to click on it. I did not have this problem with XL2000. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| synchronising pivot tables | Excel Discussion (Misc queries) | |||
| Need to create multiple Pivot tables at once | Excel Discussion (Misc queries) | |||
| Calculations in pivot tables | Excel Discussion (Misc queries) | |||
| Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
| Calculations using totals generated in Pivot Tables | Excel Discussion (Misc queries) | |||
Threaded Mode
