PivotField.Calculation (Excel)

Returns or sets an XlPivotFieldCalculation value that represents the type of calculation performed by the specified field. This property is valid only for data fields. Here you can find possible values for XlPivotFieldCalculation.

ActiveCell.PivotField.Calculation = xlDifferenceFrom