| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table: Custom formula in data area
I have a pivot table and in the data area that I want to base the
calculations off other rows in the data area. However, when type the = sign I get a message that says "Cannot change part of a PivotTable report." Is there any way around this. To give you an idea I have a field called Allocated Space in the Row area and in the Column area I have Date. The field I want to calculate is called "Allocated Space Diffrence" and it's calculated as Allocated for date selected - Previous month's Allocated. (i.e. 10/1 Allocated Space - 9/1 Allocated Space, 9/1 Allocated Space -8/1 Allocated space, etc) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot table - New Data | Excel Discussion (Misc queries) | |||
| Pivot Table Data Field Query | Excel Worksheet Functions | |||
| Pivot table - printing specific data | Excel Discussion (Misc queries) | |||
| Need Formula to display pivot table source data | Excel Worksheet Functions | |||
| How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
