Question: On the PivotTable ( shown on a picture below and the related data ) , the years and salespeople are both shown on the Column

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)?
\table[[DATES,SALESPERSON,COUNTRY,\table[[UNITS],[(#)
On the PivotTable ( shown on a picture below and

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!