I am currently trying to get data from a pivot which has this form

Sum Count Block
False True Grand Total
item1 4 4 8
item2 3 3 6
item3 3 4 7


I am trying to get "item1" "Sum Count" "Block" "False" = 4

but sinceim using excel 2000 i am not sur how to uild my path string.
can someone please help me out ?

regards,
Alexandre Brisebois

You can either link to the pivot table i.e. =B3, or you can copy the entire
pivot table and paste it somewhere else as values... right click, "paste
special", select "values".

" wrote:

I am currently trying to get data from a pivot which has this form

Sum Count Block
False True Grand Total
item1 4 4 8
item2 3 3 6
item3 3 4 7


I am trying to get "item1" "Sum Count" "Block" "False" = 4

but sinceim using excel 2000 i am not sur how to uild my path string.
can someone please help me out ?

regards,
Alexandre Brisebois

You can use the formula:

=GETPIVOTDATA($A$3,"Block FALSE Item item1")


wrote:
I am currently trying to get data from a pivot which has this form

Sum Count Block
False True Grand Total
item1 4 4 8
item2 3 3 6
item3 3 4 7


I am trying to get "item1" "Sum Count" "Block" "False" = 4

but sinceim using excel 2000 i am not sur how to uild my path string.
can someone please help me out ?

regards,
Alexandre Brisebois



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html