Pivot Tables - Please explain how to acheive the following:
Using the data below, create a Pivot Table that answers the
question “Which salesperson sold the most in any particular month.”
A manager wants to click on the Pivot Table and choose a month and
have the name of that person appear with his or her amount for that
month.
Sales
Data
Salesperson
May
June
July
Aug.
Sept.
Oct.
Albertson, Kathy
$3,947.00
$557.00
$3,863.00
$1,117.00
$8,237.00
$8,690.00
Allenson, Carol
$4,411.00...