![]() ![]() A reference to any cell, range of cells, or named range of cells in a PivotTable report. ![]() The name, enclosed in quotation marks, for the data field that contains the data that you want to retrieve The GETPIVOTDATA function syntax has the following arguments: You can quickly enter a simple GETPIVOTDATA formula by typing = in the cell you want to return the value to and then clicking the cell in the PivotTable report that contains the data you want to return. You can use GETPIVOTDATA to retrieve summary data from a PivotTable report, provided the summary data is visible in the report. The GETPIVOTDATA function returns data stored in a PivotTable report. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |