I try to add calculated column to the pivot table using win32com, but I got error as PivotFields method of PivotTable class failed for the code below:
PivotTable.CalculatedFields().Add("ST%","= Sum of Unit Sales/(Sum of Unit Sales + Sum of Inventory On Hand)")
DataField=PivotTable.AddDataField(PivotTable.PivotFields('ST%'))