In this tutorial, you will learn how to sort data in a Pivot Table.
In Excel, you can limit the data displayed in a Pivot Table by applying one or more Filters to it without affecting the design of the table.
Step 1.
To do so, click anywhere inside your Pivot Table to activate its controls, then add your filter at the Report Filter tab in the lower right pane.
![click to activate Pivot Table controls click to activate Pivot Table controls](https://howtech.tv/wp-content/images/004386/1.jpg)
Step 2.
In our case, we will filter the whole Pivot Table by quarterly results. Drag the Quarter field from the Pivot Table list pane to the Report Filter tab.
![drag Quarter field to Report Filter tab drag Quarter field to Report Filter tab](https://howtech.tv/wp-content/images/004386/2.jpg)
Step 3.
Excel will ask you if you want to replace the current filter, which is the default one created in the first cell at A1. Agree to do so and Excel will create for you a filter area.
![choose to replace current filter choose to replace current filter](https://howtech.tv/wp-content/images/004386/3.jpg)
Step 4.
Click on the filter box in the cell near Quarter to filter on-the-fly.
Checkmark Select Multiple items before you create your selection to for complex filter results.
![filter your Pivot Table filter your Pivot Table](https://howtech.tv/wp-content/images/004386/4.jpg)
Step 5.
Click OK. Excel brings you the updated results.
![get the results get the results](https://howtech.tv/wp-content/images/004386/5.jpg)
Result: Congratulations, you have learned how to sort your data in a Pivot Table.