O'Reilly logo

Microsoft ® Office 2007 Business Intelligence by Doug Harts

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

2.7. The Right Data: Filters for PivotTable and PivotChart Data

And now for the fun part: we'll click the actual PivotTable controls to change the data display on the fly. It is amazing to see how quickly people learn how to do this in the real world when the data is something they care about. The result is a feeling of control over Excel data that can help drive business decisions.

This fits right into the monitor, analyze, and plan (MAP) categories that can be used to describe what we do with data every day—if we have easy access to it. We typically use reports and the dashboard to monitor our business activities, and we can use PivotTables and PivotCharts to analyze the data. Using filters on actual PivotTables is one of the best ways to ...

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