![]() To avoid this, you can simply type the address of the cell you want (instead of clicking). The GETPIVOTDATA function is generated automatically when you reference a value cell in a pivot table by pointing and clicking. For example, you might supply the field "Region" with the item "East" to limit sales data to Sales in the East Region. Additional arguments are supplied in field/item pairs that act like filters to limit the data retrieved based on the structure of the pivot table. The second argument, pivot_t able, is a reference to any cell in an existing pivot table. ![]() The first argument, data_field, names a value field to query. GETPIVOTDATA will continue to work correctly even when a pivot table changes, as long as the field(s) being referenced is still present. ![]() The advantage of GETPIVOTDATA over a simple cell reference is that it collects data based on structure, not cell location. Use the GETPIVOTDATA function to query an existing Pivot Table and retrieve specific data based on the pivot table structure.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |