Does XlsIO prefix PivotTable calculated field headers with “Sum of”?

23 Jun 20261 minute to read

Yes. When a calculated field is added to a PivotTable, Microsoft Excel automatically prefixes the column header with Sum of before the original name. For example, a field named Profit becomes Sum of Profit. XlsIO follows the same behavior to remain consistent with Excel.