getpivotdata with 2 variables

[Guest]

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]

In Excel 2002, you could use something like:

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

 

[Guest]

Debra,

This doesn't solve my problem. I use the attendanceclass as a 3th variable.
So, I have to pick up the right attendanceclass. I can not easily state that
i work just with attadanceclassB. So, this must be an item-field combination.
I think the problem is the definition of the 'pivot table'.

Tx,

shereman

 

[Debra Dalgleish]

If you indicate which version of Excel you're using, and give an example
of some data, and what you're tryng to extract, someone may be able to help.