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

Excel will display the cell reference for the entire data set or Table object as the List Range. If you retain this selection, Excel will return a unique data set based on all the columns.

The default active cell format in Microsoft Excel isn't all that easy to see, but you can use this easy-to-implement code solution to change that.