View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default GetPivotData need help

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