<div class="raw-html-embed">
			<p>The <b>GETPIVOTDATA</b> function is one of the <a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#lookupreference" onclick="onhyperlinkclick(this)">lookup and reference functions</a>. It is used extract data stored in a PivotTable.</p>
			<h5 class="pt8">Syntax</h5>
			<p><b><em>GETPIVOTDATA(data_field, pivot_table, [field], [item], …)</em></b></p>
			<p>The <b>GETPIVOTDATA</b> function has the following arguments:</p>
			<table>
				<tbody>
					<tr>
						<th style="background-color: #f4f4f4" width="150ch"><b>Argument</b></th>
						<th style="background-color: #f4f4f4"><b>Description</b></th>
					</tr>
					<tr>
						<td><b><em>data_field</em></b></td>
						<td>Is used to set the name of the PivotTable field that contains the required data. The argument needs to be in quotes.</td>
					</tr>
					<tr>
						<td><b><em>pivot_table</em></b></td>
						<td>Is used to refer to any cell, range of cells, or named range of cells in a PivotTable. The argument is used to determine which PivotTable contains the required data.</td>
					</tr>
					<tr>
						<td><b><em>field</em>, <em>item</em></b></td>
						<td>A field/item pair. There are up to 126 pairs of field names and item names that may be used to describe the required data. The pairs can be in any order.</td>
					</tr>
				</tbody>
			</table>

	<h5 class="pt8">Notes</h5>
	<p><a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#howtoapplyfunctions_block" onclick="onhyperlinkclick(this)">How to apply</a> the <b>GETPIVOTDATA</b> function.</p>
			
			<h5 class="pt8">Examples</h5>
            <p>The figure below displays the result returned by the <b>GETPIVOTDATA</b> function.</p>
			<p><img alt="GETPIVOTDATA Function" src="https://static-helpcenter.onlyoffice.com/getpivotdata_98b219e284.png" /></p>
		</div>

GETPIVOTDATA function

Docs

Argument	Description
*data_field*	Is used to set the name of the PivotTable field that contains the required data. The argument needs to be in quotes.
*pivot_table*	Is used to refer to any cell, range of cells, or named range of cells in a PivotTable. The argument is used to determine which PivotTable contains the required data.
**field, item**	A field/item pair. There are up to 126 pairs of field names and item names that may be used to describe the required data. The pairs can be in any order.

GETPIVOTDATA function

Syntax

Notes

Examples

Host ONLYOFFICE Docs on your own server or use it in the cloud