Page History

Calculated fields are automatically generated by Excel or ExcelWriter when there are two or more data fields in the PivotTable. They are effectively read-only and the values that are returned when reading certain properties are either null or a predetermined default value. Trying to set properties on a calculated field will result in an exception.