Question: Download E 2 and make one or more Pivot Tables to be able to answer these questions: Pete had what percentage of sales in November?

Download E 2 and make one or more Pivot Tables to be able to answer these questions: Pete had what percentage of sales in November? (keep two decimal places) November had what percentage of all sales? (keep two decimal places) Mike's average sales is what amount? (enter whole dollars) What month had the largest amount of sales? \begin{tabular}{llll} Product & Reseller & Month & Sales \\ \hline Cherries & John & Oct & 250 \\ Bananas & Mike & Nov & 200 \\ Apples & Pete & Oct & 180 \\ Oranges & Mike & Nov & 400 \\ Bananas & Sally & Oct & 250 \\ Apples & Mike & Oct & 120 \\ Cherries & Sally & Sep & 330 \\ Apples & Pete & Oct & 110 \\ Cherries & Mike & Sep & 250 \\ Oranges & Sally & Nov & 200 \\ Bananas & Pete & Oct & 180 \\ Bananas & John & Nov & 400 \\ Apples & Sally & Sep & 250 \\ Oranges & Pete & Oct & 120 \\ Cherries & Mike & Oct & 330 \\ Apples & John & Oct & 180 \\ Oranges & John & Nov & 120 \\ Cherries & Pete & Oct & 330 \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
