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 ...
Get Microsoft ® Office 2007 Business Intelligence now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
