Filter, sort pivot table data
You can filter and sort the data in the rows and columns of the pivot table using the 
button in the row or column header.
After you apply a filter, the button changes to 
. When you hover the cursor, you will see a tooltip with the details of the filter.
You cannot apply multiple filters for one column or row at the same time. Setting a new filter automatically resets the old one.
Filtering by value
Select specific values to display 1.Click the 2.If you have a compact layout with multiple fields, in the window that opens, select the desired row or column from the drop-down list. 3.Make sure the By value method is selected. 4.Uncheck the Select all checkbox. 5.Select the check boxes for the values you want to keep. To search the long list, enter a part or full value in the Find field. Then check the values you find. 6.Click OK. |
Filtering by condition
This method allows you to specify rules for selecting data. Two types of conditions are available: –Filter by caption (for text values). –Filter by value (for numeric data from the value area). Set rules for data selection 1.Click the 2.If you have a compact layout with multiple fields, select the desired row or column from the drop-down list in the window that opens. 3.Select the By condition method. 4.In the Show field, select: •Captions — to filter text values. •Values — to filter numeric data. 5.When filtering by value, if there are multiple fields, select the desired one from the Field list. 6.Specify a Condition and enter a value to test. 7.Click OK. |
Resetting filters
There are two ways to delete applied filters. Delete filters for a single column or row 1.Click the filter button 2.If you have a compact layout, select the desired field from the list. 3.Click the Clear filter button. Remove filters for all filters in the table 1.Select any cell in the pivot table. 2.On the Home tab, in the Pivot table group, click |
Sorting data
You can arrange the data in a column in ascending or descending order. To sort data using the button menu 1.Click 2.In the window that opens, select the option: In ascending order or In descending order. 3.If necessary, select a field for sorting. 4.Click OK. Sort data using the context menu 1.Right-click on the cell in the desired column. 2.From the context menu, select Sort ascending or Sort descending. 3.If necessary, select a sorting option. |
