getpivotdata with 2 variables
 

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

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

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" wrote:

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

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.

shereman wrote:
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" wrote:


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





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