Exam 77-427 Microsoft Excel 2013 EXPERT 4. Create Advanced Charts and Tables 4.2 Create and Manage PivotTables: Create a Slicer

Expand the Active Field 4. What Do You See? There should be a new filter on the PivotChart legend.   The example on this page shows which sales rep sold what products.   This is an interactive PivotChart. You can filter the information by Category (Corporate, Educational, Government, Private), Product and Sales Rep.   But wait, there really is more... PivotChart Tools ->Analyze ->Active Field