The English translation translation of the Excel function HAMTA.PIVOTDATA is:
| Nederlands | English |
|---|---|
| HAMTA.PIVOTDATA |
Description
Returns data stored in a PivotTable report. You can use GETPIVOTDATA to retrieve summary data from a PivotTable report, provided the summary data is visible in the report.
Note You can quickly enter a simple GETPIVOTDATA formula by typing = in the cell you want to return the value to and then clicking the cell in the PivotTable report that contains the data you want to return.