{"id":1055,"date":"2019-05-03T15:53:13","date_gmt":"2019-05-03T12:53:13","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=1055"},"modified":"2019-05-03T16:00:15","modified_gmt":"2019-05-03T13:00:15","slug":"the-getpivotdata-function","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/the-getpivotdata-function\/","title":{"rendered":"The GETPIVOTDATA Function"},"content":{"rendered":"\n

It returns data stored in a PivotTable. You can use GETPIVOTDATA to retrieve summary data from a PivotTable, but only if the summary data is visible in the report. <\/p>\n\n\n\n

The syntax of the function is the following: <\/p>\n\n\n\n

GETPIVOTDATA<\/strong>(data_field, pivot_table, [field1, item1, field2, item2], …<\/strong><\/em>) <\/p>data_field<\/strong>: The name of the field, enclosed in quotation marks, that contains the data you want.
pivot_table<\/strong>: A reference to any cell or range of cells in a PivotTable. If the range contains more than one PivotTables then the one with the most recently created report will be used.
[field1, item1, field2, item2], …<\/strong>: Optional. Up to 126 pairs of field names and item names that describe the data we need.<\/cite><\/blockquote>\n\n\n\n

We can automatically enter the functions by typing the equals (=) sign and then clicking on the cell of the PivotTable containing the information we need.<\/p>\n\n\n\n

<\/div>\n\n\n\n\n
<\/div>\n\n\n\n

Click on the button to practice using this function, with the help of our Online Assessment Tool<\/strong>:<\/p>\n\n\n

Practice<\/a><\/p>\n\n\n\n

<\/div>\n\n\n\n\n

Here is an example of how to use the GETPIVOTDATA function:<\/strong><\/p>\n\n\n\n

Use the proper Excel function in cell G21 of the Sheet2 worksheet to get from the pivot table, the grand total of Profit for Salesman with the name Tsakalidis.<\/p>\n\n\n\n

\n