Extracting a value from the pivottablpivot table and displaying it on the main worksheet is helpful as you look through the dataset. Click or select cell H$1$ in the Qrt $1$ worksheet. insert the GETPIVOTDATA function to retrieve the grand total in the Total Gross Revenue column in the filtered pivot table.