Syntax
=GETPIVOTDATA(data_field, pivot_table, [field1], [item1], ...)Arguments
| Argument | Required | Description |
|---|---|---|
data_field | Required | The name of the value field |
pivot_table | Required | A cell in the pivot table |
field1 | Optional | A field name |
item1 | Optional | An item of that field |
How to use GETPIVOTDATA
GETPIVOTDATA takes 2 required arguments and 2 optional arguments, and accepts more values in the same pattern. Type =GETPIVOTDATA( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=GETPIVOTDATA("Sales", A1)Result Related lookup and reference functions
- CHOOSEReturns the value in a list at the given position.
- COLUMNReturns the column number of a reference, or of the cell with the formula when left out.
- COLUMNSReturns the number of columns in a range or array.
- FORMULATEXTReturns the formula in a cell as text.
- HLOOKUPLooks for a value in the first row of a table and returns the value in the same column from another row.
- INDEXReturns the value or reference at a given row and column of a range or array.
- INDIRECTReturns the reference written in a text value, such as "B3" or "Sheet2!A1:A10".
- LOOKUPFinds a value in a sorted row or column and returns the value at the same position in another row or column.
- MATCHReturns the position of a value in a row or column.