Question: Eva also wants to create a PivotTable that includes data about sales representatives and their sales. She already added the tables containing this data to

  1. Eva also wants to create a PivotTable that includes data about sales representatives and their sales. She already added the tables containing this data to the Data Model. Eva wants to list each sales rep by name along with their region, number of products sold, and total amount of sales. Create a PivotTable that displays this information as follows:
    1. Use Power Pivot to create a PivotTable on a new worksheet, using Sales Reps as the name of the worksheet.
    2. Display the LastName field values from the Query SalesReps data source as row headings.
    3. Display the Region field values from the Query SalesReps data source as column headings.
    4. Add the TotalSales field from the Query - Sales data source to the Values area to sum the field values.

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 General Management Questions!

Q:

All facts about this NFPO are identical to those described in Problem 10, except that the deferral method of recording contributions is used for accounting and for external financial reporting. Fund...

Q:

HI Invoicelu" Contract" InvoiceD Invoiceitem Invoiced: InvoiceF 1011 8111 2/2712021 Indoor alarm system 500.00 TRUE 1012 9111 5/10/2021 Indoor alarm system $ 1,500.00 TRUE 1021 9112 2/25/2021 Front...

Q:

Design Layout References Mailings Review View Help Helvetica 115 - A A A BEA14 3 IU alex, A - A - et 1 Normal 1 No SpacHeading 1 Heading 2 Tube Font Paragraph yes Bluth Corporation is one of the...

Q:

all questions by writing down the correct answer among the options given in the question below. Question 1 Marilyn added a few calculated fields and items to a PivotTable and wants to document the...

Q:

Bluth Corporation is one of the oldest and most successful companies in Southwestern Ontario region. Founded in 1920, it is a leader in office supplies and safety products. Its primary line of...

Q:

Bluth Corporation is one of the oldest and most successful companies in Southwestern Ontario region. Founded in 1920, it is a leader in office supplies and safety products. Its primary line of...

Q:

Bluth Corporation: Redesigning Management Information Systems (MIS) Bluth Corporation is one of the oldest and most successful companies in Southwestern Ontario region.Founded in 1920, it is a leader...

Q:

Bluth Corporation is one of the oldest and most successful companies in Southwestern Ontario region. Founded in 1920, it is a leader in office supplies and safety products. Its primary line of...

Q:

Bluth Corporation: Redesigning Management Information Systems (MIS) Bluth Corporation is one of the oldest and most successful companies in Southwestern Ontario region.Founded in 1920, it is a leader...

Q:

Bluth Corporation: Redesigning Management Information Systems (MIS) Bluth Corporation is one of the oldest and most successful companies in Southwestern Ontario region.Founded in 1920, it is a leader...

Q:

Help me to write a memo summarizing an in-depth analysis of the key questions listed in the context of the facts presented in the case study. Bluth Corporation: Redesigning Management Information...

Q:

Think back to the external environmental conditions (cultural, legal-political, and economic) discussed in Chapters 2 through 4 and discuss how these have affected and might affect future demands for...

Q:

The following companies have different financial statistics. What dividend policies would you recommend for them? Explain yourreasons. Turtle Co. 2290 Hare Corp. Growth rate in sales and earnings...

Q:

17. Discuss the appropriate treatment in the financial statements of each of the following. a. Write-down of plant assets due to impairment. b. A delivery expense on goods sold. c. Additional...

Q:

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...