Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table SUMS
Hi,
Im writing some formulas beside a Pivot table, which I expect they will work automatically every time I change a parameter in the report filters. The problem is this: How can i automatically add up my formulas everytime the pivot table shows a subtotal??? Remember the subtotal´s position will change everytime I change a parameter in the filters. Tricky one, isn´t it??? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table SUMS
Hi,
Excel will not automatically put new formulas in the spreadsheet for you. But if you want the formulas that are referencing the pivot table to adjust as you modify the pivot table you can use the GETPIVOTDATE function, here is an example: =GETPIVOTDATA("Emp",$G$3,"Region","W","Department" ,"Dept15") If your data comes from an external data source, for example Access, then you can set a property of the connection to cause adjacent formulas to update. If this helps, please click the Yes button. Cheers, Shane Devenshire "John Pivot Table" wrote: Hi, Im writing some formulas beside a Pivot table, which I expect they will work automatically every time I change a parameter in the report filters. The problem is this: How can i automatically add up my formulas everytime the pivot table shows a subtotal??? Remember the subtotal´s position will change everytime I change a parameter in the filters. Tricky one, isn´t it??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot question about sums | Excel Discussion (Misc queries) | |||
Pivot Table Sums | Excel Discussion (Misc queries) | |||
pivot table_reversing sums and groups | Excel Discussion (Misc queries) | |||
All 0's for Sums in Pivot Table | Excel Discussion (Misc queries) | |||
Cumulative Sums in Pivot Tables | Excel Worksheet Functions |