If the data you want to display in your pivot table fits a rule, such as “all values greater than one thousand”, you can define that rule and use it to filter your pivot table.
- [Narrator] Pivot tables help you summarize large amounts…of data, but you can always limit the data…that appears by creating a filter.…If the data you want to display in your pivot table…fits a rule, such as all values…greater than 1000, you can define that rule…and use it to filter your pivot table.…In this movie, I'll demonstrate how to do that.…My sample file is 02_02_Rule, and you…can find it in the Chapter Two folder…of your exercise files collection.…This workbook contains two worksheets,…the first is Sheet one, which contains my data,…and the second is Pivot Table two,…which has the pivot table that you see now.…
If you want to filter your pivot table,…then click any cell within the body of the pivot table,…and then on the tool bar, if necessary click more.…If the pivot table editor is hidden,…such as by clicking its close button,…then you will see the filter button…pop up by itself.…On the other hand, if I bring the pivot table…editor task pane back, then I need to click the more button,…and that displays all of the other controls on the tool bar.…
- Arranging data for use in a pivot table
- Editing the data source
- Creating a calculated field
- Sorting values
- Filtering a pivot table by rule, selection, or filter field