Pivot table SUMS

[John Pivot Table]

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???

 

[Shane Devenshire]

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