Code: Select all
pt.AddDataField(pt.PivotFields("Amount"), "Sums", xlSum)
pt.AddDataField(pt.PivotFields("Amount"), "Std Devs", xlStDevP)
Total Sums is confusing & Total Std Devs makes no sense. I would like to have the column labels be Total & Overall Std Dev.
I was excited to find PivotTable.GrandTotalName, but that onlt changes the row label on the last row.
Eithe a VBA or manual solution would be fine, but Excel says I cannot edit it when I try manually.