In Excel 2002, you could use something like:

=GETPIVOTDATA("Sum of attendanceclassB",$A$6,"Area","West",
"Price","Low")

shereman wrote:
Hello,

I have a pivot table with 2 variables, and 3 types of data into it. It looks
like this
Price
Area sum of attendanceclassA
sum of attendanceclassB
sum of attendanceclassC

What do I have to fill in as 'pivot table' when using the "getpivotdata"
function? It clearly worked well when using just one attendanceclass. Then I
filled in 'sum of attendanceclassA', but with 3 sorts of data in it, it
doesn't.

Thanks




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html