PivotTable.ShowValuesRow (Excel)

Returns or sets whether the values row is displayed.

This property corresponds to the setting of the Show the Values row check box on the Display tab of the PivotTable Options dialog box.

ActiveCell.PivotTable.ShowValuesRow = True