Modify the PivotTable report on Sheet1 to answer the question, "What are the fourth quarter sales values?"
Select Sheet1 and verify that the PivotTable is selected.
In the PivotTable Fields task pane, in the Choose fields to add to report section, drag and drop Quarter to the Filters area.
Verify that Quarter is in cell A1 and a filter is in cell B1.
Select the drop-down arrow in cell B1, select Quarter 4, and then select OK.
Verify that Quarter 4 total sales are 1,842,121.272.