Syntax :

=GETPIVOTDATA( data_field, pivot_table, [field1], [item1], [field2], [item2], …)

Parameters :

The following parameters are :

• Data field – The pivot table data field that you wish to extract (i.e. the data header in your original data collection).

• Pivot table – A reference to any cell or range of cells in the Pivot Table that will be searched.
  (This reference only specifies the pivot table.)

• [field1], [item1], [field2], [item2], etc. – You can specify up to 126 optional pairs of fields and item names (i.e. the row and column headings, as well as specific categories) for which you wish the returned value.

• Please keep in mind that the item values should be entered as follows:

• Numbers can be simply inputted;
  Dates should be supplied using date serial numbers or the date function.

• Times should be entered in decimal form or by using the time function.

• Text values should be surrounded by quote marks.