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,