subtotal formula for pivot table

[Ashley]

I have used this formula to total the difference of my Count of Opened column and my Count of Credit Pulled column


=GETPIVOTDATA("Count of Opened",Sheet2!$C$34)-GETPIVOTDATA("Count of Credit Pulled",Sheet2!$D$34)


this formula works great. but it only totals the GRAND TOTAL in the pivot table, I need it to total the SUBTOTALS in the pivot table

 

[fred]

Try


=GETPIVOTDATA("Count of Opened",$A$3,"Region","C")-GETPIVOTDATA("Count of Credit Pulled",$A$3,"Region","C")


Where "C" is the subtotal of subject matter and "Region" is the category where subtotal was picked.


I hope this will give you some idea.

 

[Ashley]

thanks I'll give it a shot