{"id":1276,"date":"2015-05-26T16:18:13","date_gmt":"2015-05-26T14:18:13","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=1276"},"modified":"2024-02-06T15:45:32","modified_gmt":"2024-02-06T14:45:32","slug":"getpivotdata-function","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/getpivotdata-function\/","title":{"rendered":"GETPIVOTDATA Function"},"content":{"rendered":"

What does it do?<\/strong><\/em><\/p>\n

A formula that extracts data stored in a Pivot Table<\/a><\/p>\n

Formula breakdown:<\/strong><\/em><\/p>\n

=GETPIVOTDATA(data_field,\u00a0pivot_table,\u00a0[field1, item1],\u00a0[field2,item2],…<\/span><\/span><\/span><\/span><\/span><\/span><\/span>)<\/p>\n

What it means:<\/strong><\/em><\/p>\n

=GETPIVOTDATA(return me this value from the Values Area,\u00a0any cell within the Pivot Table,\u00a0[and return me the value that pertains to this Field name, and this Field item],…<\/span><\/span><\/span><\/span><\/span><\/span>)<\/p>\n

\n

 <\/p>\n

The GETPIVOTDATA function in Excel returns data stored in a Pivot Table.\u00a0 So essentially it extracts the Pivot Table data to enable a user to create customized reports.<\/p>\n

Think of the Pivot Table like your data source, so anything you see in the Pivot Table report can be extracted with the GETPIVOTDATA function and put into a cell within your worksheet.<\/p>\n

The GETPIVOTDATA function becomes powerful when you reference cells to create shell reports, which you can see from the tutorial below.<\/p>\n

NB. Only the Fields and Items that are included in the Pivot Table report (Row\/Column Labels and Values area) can be used to extract their values.<\/em><\/p>\n