Analysis: Use the Active Field 3. Try it: Expand the Active Field Go to PivotChart Tools->Analyze. Go to Active Field. Click on Expand Entire 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... Exam 77-888: Microsoft Excel Expert 2010 3. Presenting Data Visually 3.4. Apply and manipulate PivotCharts: Analyze Data with the Active Field PivotChart Tools ->Analyze ->Active Field