On the PivotTable (shown on a picture below and the related data), the years and salespeople are both shown on the Column A. What should you do to separate the years and the salespeople in two separate columns so that years are shown on the Column A and salespeople are on the Column B (as it is shown in Table 1)?
DATES SALESPERSON COUNTRY UNITS (#) AMOUNT ($) PRODUCT
8/24/2009 Tim Short USA 1300 $44,200 MACHINERY
12/28/2009 Mark Anthony USA 5000 $185,000 FOODS
8/17/2008 Kim Wong CAN 500 $23,000 FOODS
11/23/2010 Heather Green UK 800 $89,200 CLOTHING
12/30/2008 Duncan Lease CAN 1700 $45,900 MACHINERY
10/4/2009 Heather Green UK 800 $223,200 CLOTHING
8/17/2008 Kim Wong CAN 500 $23,000 FOODS
none of the answers is correct
Click on Design option, select Actions from the top menu, and click on "Do not Move PivotTable" option.
Click on Design option under PivotTable Tools menu option, select Report Layout from the top menu, and click on "Show in Outline Form" option.
Click on Analyze option under PivotTable tools, select Actions from the top menu, and click on "Move PivotTable" option.
Click on Analyze option under Actions menu option, select Report Layout from the top menu, and click on "Show in Outline Form" option.