This field must be visible in the pivot table.
Get pivot table subtotal
To get the subtotal for a value field in a pivot table, you can use the GETPIVOTDATA function. In the example shown, the formula in I6 is: =GETPIVOTDATA("Sales",$B$4,"Product","Almond") Although you can reference any cell in a pivot table with a normal reference (i.e. F8) the GETPIVOTDATA will continue to return correct values even when the pivot table changes.
