software

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 7I am trying to get quot;item1quot; quot;Sum Countquot; quot;Blockquot; quot;Falsequot; = 4

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

regards,
Alexandre BriseboisYou 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, quot;paste
specialquot;, select quot;valuesquot;.

quot; wrote:

gt; I am currently trying to get data from a pivot which has this form
gt;
gt; Sum Count Block
gt; False True Grand Total
gt; item1 4 4 8
gt; item2 3 3 6
gt; item3 3 4 7
gt;
gt;
gt; I am trying to get quot;item1quot; quot;Sum Countquot; quot;Blockquot; quot;Falsequot; = 4
gt;
gt; but sinceim using excel 2000 i am not sur how to uild my path string.
gt; can someone please help me out ?
gt;
gt; regards,
gt; Alexandre Brisebois
gt;
gt;

You can use the formula:

=GETPIVOTDATA($A$3,quot;Block FALSE Item item1quot;)

wrote:
gt; I am currently trying to get data from a pivot which has this form
gt;
gt; Sum Count Block
gt; False True Grand Total
gt; item1 4 4 8
gt; item2 3 3 6
gt; item3 3 4 7
gt;
gt;
gt; I am trying to get quot;item1quot; quot;Sum Countquot; quot;Blockquot; quot;Falsequot; = 4
gt;
gt; but sinceim using excel 2000 i am not sur how to uild my path string.
gt; can someone please help me out ?
gt;
gt; regards,
gt; Alexandre Brisebois
gt;--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html