using getpivotdata function
 

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.


--
dreamz
------------------------------------------------------------------------
dreamz's Profile: http://www.excelforum.com/member.php...o&userid=26462
View this thread: http://www.excelforum.com/showthread...hreadid=466939

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