Search code examples
excelpivotaveragesubtotal

How do I access subtotals from a pivot?

I've got a pivot with an average value and I need to be able to access it in another spreadsheet, how can I do this? It seems like I cannot access any subtotals.

Heres the value of the cell:

=GETPIVOTDATA($A$3,"'1/2/2011 - 1/8/2011' operation_id['4';Data,Average] 'Sum of Estimated Hours / Paid Per Operation'")

Mousing over the #REF seems to indicate that there are missing or deleted cells but I haven't deleted anything.

Solution

  • http://office.microsoft.com/en-us/access-help/about-calculating-totals-in-pivottable-view-HP003084426.aspx

    "Callout 1 The Sum of Sales total field. You cannot add total fields to the row, column, or filter area."