Question: Step 4: Cross-Tab Worksheet Make a new worksheet, title it Cross Tab. Create a filter for Product Line by dragging the individual field from the

Step 4: Cross-Tab Worksheet Make a new worksheet, title it "Cross Tab". Create a filter for Product Line by dragging the individual field from the dimensions to the filter card. Use all values. Apply it to all worksheets using this data source. Show the Customer State and Product Line filters on this new worksheet filter. Add the product line hierarchy to the rows. Add the field "Customer State" to the columns shelf. Add the field "Sales Revenue directly to the cross-tab table so the numerical values are displayed. Choose the option which provides a visual cue for colors for the numerical values. From the menus, choose Analysis / Totals, and add the totals for the rows and columns. Cross Tab Producte a. 9. What are the total sales in the state of North Carolina? b. $1,263,455 c. $310,810 d. $252,275 e. $83,460 f. $346,215 10. What are the total sales for Printers in all states? a. b. $192,960 c. $40,420 d. $493,900 e. $192,960 f 729135 11. What are the total sales for Consumables in Georgia? a. b. $3,630 c. $40,420 d. $77,735 e. $85,570 f. $18,745 Expand the product line hierarchy to show the results for the product segments. 12. What are the total sales for Toner in North Carolina? a. b. $13100 c. $17490 d. $6090 e. $1680 f. $3350 Step 4: Cross-Tab Worksheet Make a new worksheet, title it "Cross Tab". Create a filter for Product Line by dragging the individual field from the dimensions to the filter card. Use all values. Apply it to all worksheets using this data source. Show the Customer State and Product Line filters on this new worksheet filter. Add the product line hierarchy to the rows. Add the field "Customer State" to the columns shelf. Add the field "Sales Revenue directly to the cross-tab table so the numerical values are displayed. Choose the option which provides a visual cue for colors for the numerical values. From the menus, choose Analysis / Totals, and add the totals for the rows and columns. Cross Tab Producte a. 9. What are the total sales in the state of North Carolina? b. $1,263,455 c. $310,810 d. $252,275 e. $83,460 f. $346,215 10. What are the total sales for Printers in all states? a. b. $192,960 c. $40,420 d. $493,900 e. $192,960 f 729135 11. What are the total sales for Consumables in Georgia? a. b. $3,630 c. $40,420 d. $77,735 e. $85,570 f. $18,745 Expand the product line hierarchy to show the results for the product segments. 12. What are the total sales for Toner in North Carolina? a. b. $13100 c. $17490 d. $6090 e. $1680 f. $3350

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!

Step 3: Product Sales Click on the icon "New Worksheet". Rename the new sheet "Product Sales". Crate a hierarchy. Name it "Product Line Hierarchy". Include the following dimensions in the hierarchy:...

Version - Applied Analytics Part 4 Step 1: Import the data Connect to the Excel file. "Business Analytics Tableau Lab Quiz". There is just one worksheet, "invoices Tables should automatically import...

Project Description: The sales team at the Painted Treasures Gift Shop would like to review its staffs sales after some of the new staff members have finished a sales training program. You have been...

The resulting bar chart shows that when HMK is the AR Clerk and FKL is the Cash Receipts Clerk, CT is the GL Accounting Clerk for $226,851 of current AR balances. However, there are $25,352 of...

1. Casel Ivana's Ice Cream just finished its first six months of manufacturing and selling ice cream. The company has two main product lines, Ice cream cups and ice cream bars, both of which are...

43 AaBbCcDc AaBbc AaBbCc) AaBbCcDd AaBbCcDd Emphasis Heading 1 Heading 2 11 Normal 1 Normal ... Paragraph Styles Instructions Points Possible exercise begins on page 343 of your text. Start Excel....

help me Excel_Comprehensive_Capstonel_Wint ect Description: s project, you will apply skills you practiced from the objectives in Excel Chapters 4 through 10. You will develop a book for Frank Osei,...

Hello tutor Please find the attached instruction file and use the template for solving this question. If you have any question about the problem please contact me. Thanks Your Course Project...

The accounting records for Beta Company contained the following balances as of December 31, 2008, as shown on the year-end balance sheet: Additional information follows: Salaries that had been...

The closing value of the AMEX Airline Index for each trading day during a one-year period is given in the file P12_17.xlsx. a. Use the random walk model to forecast the closing price of this stock on...

uccording to the insider trading rule, managers are not required to reveal important nside information they possess before trading on it themselves True False

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...