using getpivotdata function

[dreamz]

hello,

how do i use the getpivotdata function? i used the pt to sum up the objects for my categories (ST, Code, Value).

example:

=GETPIVOTDATA("sum of objects",$A$4,"ST",M4,"Code","1","Value","True")

ST = state
M4 = first state in another list
Code = name of field
1 = Code 1
Value = name of another field
True = the value, either true or false

in M4, i have AK for alaska, and continuing on down the sheet, i have the rest of the states in alphabetical order (so AL, AR, AZ, etc.), so it looks like:

AK
AL
AR
AZ
CA...

basically, i want the cell N4 to be the number of objects for AK, where the value is taken from the pt, where the state is AK, where the Code number is 1, and where the value is true.

i know the formula i used doesn't work. is there a way i can get this to work so that it automatically looks up the state and puts in the value (like a beefed up vlookup)?

thanks.

[Debra Dalgleish]

Your formula looks like it should work. What result do you get?

dreamz wrote:
> hello,
>
> how do i use the getpivotdata function? i used the pt to sum up the
> objects for my categories (ST, Code, Value).
>
> example:
>
> =GETPIVOTDATA("sum of objects",$A$4,"ST",M4,"Code","1","Value","True")
>
> ST = state
> M4 = first state in another list
> Code = name of field
> 1 = Code 1
> Value = name of another field
> True = the value, either true or false
>
> in M4, i have AK for alaska, and continuing on down the sheet, i have
> the rest of the states in alphabetical order (so AL, AR, AZ, etc.), so
> it looks like:
>
> AK
> AL
> AR
> AZ
> CA...
>
> basically, i want the cell N4 to be the number of objects for AK, where
> the value is taken from the pt, where the state is AK, where the Code
> number is 1, and where the value is true.
>
> i know the formula i used doesn't work. is there a way i can get this
> to work so that it automatically looks up the state and puts in the
> value (like a beefed up vlookup)?
>
> thanks.
>
>


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