Getpivotdata
Posted by IML on October 12, 2001 9:02 AM
Let say you have the following formula pointing towards a table named PIVTAB1
=GETPIVOTDATA(PIVTAB1,"1 sum of Fund Value Q4/00")
to retrieve the Fund value of fund 1 for the Q4/00 period.
Is it possible to replace 1 and Q4/00 with cell addresses. If so, what would the format be?
Thanks in advance,
Ian