The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

Here is where Excel pivot tables step in to extract data, which can help you avoid getting lost in endless rows and columns.