O'Reilly logo

Picture Yourself Learning Microsoft® Excel® 2010 by Laurie Ulrich Fuller, Deidre Hayes, Jeffery A. Riley

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Sorting and Filtering PivotTable Data

BY DEFAULT, ALL THE RECORDS in your designated filter field are included in the PivotTable report—in this example, all departments were shown in Figure 15-6. Of course, it’s easy to reduce that to show just one department or a selected group of departments, instead. You can also filter which job titles are shown, so that you see only certain jobs in certain departments. Figure 15-14 shows the report reduced to show only the Sales department, with only the sales reps’ names and salaries totaled.

Figure 15-14. Distill the report down to just the one or two filter fields you’re interested in, and then decide how much detail you want about each one.

Filtering PivotTable Fields

To filter ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required