PivotTable.CompactLayoutColumnHeader (Excel)
Specifies the caption that is displayed in the column header of a PivotTable when in compact row layout form.
When the user customizes these captions in the grid, it is also reflected in this property.
ActiveCell.PivotTable.CompactLayoutColumnHeader =