Construct a pivot table for sum of amount sold

Reference no: EM132225630

Assignment -

The XYZ Company sells different merchandise through different salespersons in different states. The sales manager is interested in knowing who sold what, where, and how much. Using the sample data construct a pivot table for each (A Pivot table must be created for each letter. There should be a total of 5 pivot tables created) of the items below:

A. Sum of Amount Sold

B. Total sales broken down into three regions

C. Performance of each salesperson in each region

D. Sales broken down by region, then by salesperson, and then by Merchandise

E. Two-dimensional table that shows sales performance by region and type of merchandise

The following are guidelines to the required format:

A pivot table should be created for each of the items above.
Copy the Pivot Table from Excel into a word document and place the corresponding label at the top of each pivot so I am able to identify which pivot table was constructed.

Note - Excel newest one or 2012 Version needed.

Attachment:- Assignment Files.rar

Reference no: EM132225630

Questions Cloud

Defend your final decision based on your decision tree : Determine the expected value, and defend your final decision based on your decision tree.

Challenges your culture and cultural identity : We should be more sensitive to the ways that your educational curriculum reinforces or challenges your culture and cultural identity.

What are the effective strategic planning : What are the basic steps required in the process of initiating the strategic planning process? Share how your own organization, or one you are familiar.

Despite the commonsense appeal of emporwering employess : Despite the commonsense appeal of emporwering employess, empowement is not universally embraced for several reasons. List five.

Construct a pivot table for sum of amount sold : The XYZ Company sells different merchandise through different salespersons in different states. Construct a pivot table for Sum of Amount Sold

Develop a narrated kaltura video presentation : Develop a narrated Kaltura video presentation that identifies and explains the importance of the critical points that emerged from Tasks 1 and 2 (above).

Calculate new process capability : What can you say (quantitatively) regarding the process capability? Calculate the new process capability.

What is the most common mistake about diversity : What is the most common mistake about diversity? How do you respond to individual differences in the workplace?

What is legal basis for the termination of offer : There are several reasons that an offer may terminate. What is a legal basis for the termination of an offer? Provide an example.?

User Account

All Pages