I have created a Pivot Table that looks as follows;
Values
0 To 3 Months 200
3 to 6 Months 111
6 to 12 Months 121
12 to 18 Months 70
18 to 24 Months 24
Over 24 Months 32
The column with the totals you will note does not have a title. So, how do I use GETPIVOTDATA to extract the data; I have started with something like this;
=GETPIVOTDATA(?????,$B$4,"Values","0 To 3 Months")
which I want to return the value of 200. Where $B$4 is the top left hand corner of the Pivot Table, and the ????? is the bit I don't know.
Can anyone help?
Many thanks in anticipation
Bookmarks