Exam 77-427 Microsoft Excel 2013 EXPERT 4. Create Advanced Charts and Tables 4.2 Create and Manage PivotTables: Expand the Active Field

Analysis: Use the Active Field 3. Try it: Expand the Active Field Go to PivotChart Tools->Analyze. Go to Active Field. Click on Expand Field.   What Do You See? You will be prompted to choose which data you would like to show. Our question was: Who sold what? If you choose Sales Rep, the PivotChart will display the names of the people who sold products.   Try this, Too: Select a Field for the Detail Show Detail: Sales Rep.   Please click OK and keep going... PivotChart Tools ->Analyze ->Active Field->Expand Field