81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199

Better Sheets
Create Free accountMember Login

GETPIVOTDATA()

Description

Extracts an aggregated value from a pivot table that corresponds to the specified row and column headings.

How To Use in Sheets

GETPIVOTDATA(value_name, any_pivot_table_cell, [original_column, ...], [pivot_item, ...]

External Links

GET PIVOT DATA

Google Docs Help

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.