Exam 77-427 Microsoft Excel 2013 Expert 4. Create Advanced Charts and Tables 4.2 Create and Manage PivotTables: Use PowerPivot Perspectives Advanced ->Perspective-> Select

Edit the Perspectives There are two Perspectives in this Excel file. You can view and edit each one.   3. Try This: Select a Perspective The PowerPivot window is still open. Go to Advanced ->Perspective->Select. Click on Boston. What Did You See? The data in tblProducts has been formatted and filtered for the "Boston" view. Earlier in this lesson, we formatted the Price as Currency (dollars). There is also a Filter on the Discontinued Field. This Table does not show the ones that were discontinued (TRUE). Keep going...