Exam 77-427 Microsoft Excel 2013 Expert 4. Create Advanced Charts and Tables 4.2 Create and Manage PivotTables: Use PowerPivot Perspectives (Power Pivot Reports)

Select the Power View Fields 7. Try it: Select the Power View Fields Drag the Power View Fields to the following areas: Add to FIELDS: Choose Price from tblProducts. Choose Item from tblProducts. Add to TITLE BY: Choose Type from Table_tblType. Made You Look: The Price Field has a formula: SUM. The SUM function works because this is money. The ProductID also has a formula: COUNT. The COUNT function is appropriate because ProductID is an Integer, a whole number.   Keep going... Power View-> View->Field List