
These can be text or dates under Row Labels.

To view only the items in your PivotTable that you want, you can select the cells that contain the items.

Slicers are one of the best ways to filter your PivotTable data.įor information about using slicers, see the 4th video in this course- Use slicers, timelines, and PivotCharts to analyze your PivotTable data. To remove the filter, click the down arrow again, it now looks like a funnel because a filter is applied. And only genres of books that start with "c" are displayed. Type your criteria, such as the letter c, and click OK. Since we clicked the down-arrow for a label, point to Label Filters.Ĭlick an option, such as Begins With. It helps you focus on the data you want to analyze.Ĭlick the down-arrow next to Row Labels. On the Quick Access Toolbar, click Undo, to undo the sort. Right-click a value, such as the Grand Total for the Arts & Photography genre, point to Sort, click Sort Largest to Smallest, and the Genres are sorted from the largest to smallest Grand Total Sales amounts.

One of the most common ways is sorting, it helps you quickly see trends in your data. You can analyze PivotTable data in many ways.
