This is a Pivot Table produced from PowerPivot. The totals I want to get hold of are all derived using CALCULATE(), and are 'Values' in the Pivot Table. I don't know why it does not have a column heading, and I cannot see how to add one.
I can't attach the spreadsheet, because it is dependent on data that is on a database,so it would not work. The following though is a screen shot;
Capture.PNG
Bookmarks