Try this. GetPivot Data can refenece more than one dimension iun the second
argument...

=GETPIVOTDATA(A1, "Result F")
--
HTH...

Jim Thomlinson


"Enrico Campidoglio" wrote:

Hi!

I have a pivot table with the following layout:
[Count of results]
[Status] [Result]
P F Grand Total
A 10 3 13
B 15 8 23
C 5 4 9
Grand Total 30 15 45

A1 = [Count of results]

i am using the GetPivotData function to retrieve the grand totals but i can
only
retrieve the row grand totals (13, 23, 9) and not the column grand totals
(30, 15, 45).
Here is what i tried:
=GETPIVOTDATA(A1, "A") -- 13
=GETPIVOTDATA(A1, "Result") -- 45
=GETPIVOTDATA(A1, "P") -- #N/A
=GETPIVOTDATA(A1, "F") -- #N/A

I have tried using cell references but it doesn't make any difference.
I read many different how-tos about this function but the only solution i
found assumed the presence of column sub-totals.

What am i doing wrong? Help is appreciated

--
Thanks in advance
/Enrico