The GETPIVOTDATA function returns data stored in the given pivot table.ġ) The calculated fields and custom calculation filed such as Grand Total and Sum of EachProwduct also can be as arguments in GETPIVOTDATA function.Ģ) If an item contains a date or time, the returned value may lose if the workbook is moved to another location and displayed as error value #REF!. If the filed names and item names are non-numeric value, you need to enclose them with quotation marks. 1 to 126 pairs of field names and item names that indirect the data that you want to retrieve. A cell or a range of cells or a named range used to determined which pivot table you will retrieve data from. Enclosed with double quotas, the field name contains the data you want to return. Syntax and argumentsįormula syntax =GETPIVOTDATA ( data_field, pivot_table,. The GETPIVOTDATA function queries a pivot table and returns data based on the pivot table structure.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |