Hi,

I am not familiar with this function.
I tried, but it didnt work in my case because my fields get re-arranged
into many configurations very often.
But I will use it for other more fixed type of pivot tables.
Thanks.

Ju


Barb Reinhardt wrote on 19-Feb-2006 9:18 PM:
I just created a quick pivot table with NAME and #. I went to a cell
outside the table and had it reference the grand total. This is what I got
for a formula

=GETPIVOTDATA("#",$A$3)

When I added more data items, I got this
=GETPIVOTDATA("Count of #",$A$3)
=GETPIVOTDATA("Sum of #",$A$3)

$A$3 is where the top right corner of the pivot table is located.

"Ju" wrote in message
...
Hi all,

I need help on the last part of the formula:


=OFFSET($A$1,(MATCH("Grand Total",A:A,0)-1),COUNTA("where the cell in
column a contains "Grand total"))

This is for referencing the grand total in a pivot table..

I can't use a static top row, as it may contain blank cells, as fields are
added or removed.


Thank you.

Ju