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