Extract subtotals (averages) from Pivot Table

Giganews Newsgroups
Subject: Extract subtotals (averages) from Pivot Table
Posted by:  Takeadoe (mtonkovi…@msn.com)
Date: 29 Jan 2007

Dear Ng,

Its probably staring me in the face, but I don't see it. Can anyone
tell me if it is possible to extract just the row subtotals (actually
averages) from a Pivot Table? There would be 88 averages, each
separated by 6 records. IOW, the Pivot Table has 88x5 rows in it, or
thereabouts.

I've tried this, but I get the nasty "REF#" message in the cell.

=GETPIVOTDATA($A$3,"COUNTY[Ashland;Data,Average] 'ProRvPreR '")

I have 88 subtotals I'm trying to extract. Perhaps there is a way
to "hide" all of the rows in the table except the subtotals (i.e.,
averages).

Thanks in advance,

Replies