The GETPIVOTDATA Function

Kornilios Ampatzis/ May 3, 2019/ Functions

It returns data stored in a PivotTable. You can use GETPIVOTDATA to retrieve summary data from a PivotTable, but only if the summary data is visible in the report.