View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Pivot Table[_2_] John Pivot Table[_2_] is offline
external usenet poster
 
Posts: 10
Default 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???