Question: how to apply this in a piviot table Element #2: Proportion of Sales Revenue by Product On your Other Calcs worksheet create a new pivot

how to apply this in a piviot table Element #2: Proportion of Sales Revenue by Product On your "Other Calcs" worksheet create a new pivot table from the Raw Data Table. Use Product in the rows and present the total sales revenue for each product in the current year as a % of the total sales revenue. Sort it from largest to smallest percentage. To make it cleaner, only show those products whose sales are 15% or more of the total in the current year and group the other products together to represent "all other" products. Make a chart of this and put it on your dashboard. Be sure your final chart does not show the details of what is in "All other". You must determine the proper type of chart to show. Make a note of how many products had to be combined in the "all other" group

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 Accounting Questions!

how to apply this in a piviot table Element #1: Total Sales Revenue by Region for the Current Year Create a static bar chart that presents total Sales revenue by sales region for the current year

Question: What as the average weekly safety inventory level of refined sugar from the beginning January 2022 to the end of July 2022? A. 512,465.9691 metric tons per week B. 316,002.1474 metric tons...

Hello. Can you help with this four question problem? Case PRIVATE EQUITY CASE: MERGER CONSOLIDATION The questions below COMBINE the Ohio & Maryland PT acquisitions as if they are a single c Learning...

Data Files needed for the Review Assignments: NP_EX_10-2.xlsx, Support_EX_10_Sales01.csv, Support_EX_10_Sales02.csv, Support_EX_10_Sales03.accdb Dmitry has another set of sales data for you to...

please help DATE VALUE VALUE MEASURECurrentDate(TODAY)CurrentTime(NOW)VALUE#N/AFORMULA#N/A Use E6 "Problem Date" for green cells in col. E \& I 11/11/2019 Problem Date Year (YEAR) Month (MONTH) \#N/A...

Hello ther, I need help with my finance case study (Ramsey Co. Case study). Please see the attachments for details and instructions. Thanks, Ramsey Inc. 2013 Purchase Order Register March 1, 2013 -...

Review AssignmentsData Files needed for the Review Assignments: NP_EX_10-2.xlsx, Support_EX_10_Sales01.csv, Support_EX_10_Sales02.csv, Support_EX_10_Sales03.accdbDmitry has another set of sales data...

Data Files needed for the Review Assignments: NP_EX_10-2.xlsx, Support_EX_10_Sales01.csv, Support_EX_10_Sales02.csv, Support_EX_10_Sales03.accdb Dmitry has another set of sales data for you to...

1 Start Excel, and then open the downloaded file last_exc_ch5-6_ _df.xlsx. (Srader has automatically added your last name to the beginning of the filename. Save the file to the location where you are...

In a basket purchase, all assets that are part of the purchase must be depreciated over the same useful lives. Do you agree? Explain.

Q1. Referring to the figure below, explain how to separate the higher layer protocols and the lower layer protocols. Q2. How the transport layer and network layer complements each other to provide...

Polar Slope. Find a simplified formula for the derivative o f the given polar function, and use i t t o find the exact rectangular coordinates o f two different points where the slope i s - 1 . r = 1...

4. Boxowitz, Inc., a computer firm, markets two kinds of calculators that compete with one another. Their demand functions are expressed by the following relationships: 9 = 64 - 4p1 - 2p2 and ter 92...

1. What do you think were the biggest factors in the failure of the incentive program at HP? 2. Why might employees prefer to have only fixed pay and no incentive pay if the incentive pay system...

When businesses enter global markets what do you think the role of managers should be in minimizing harm to foreign workers and the environment? address the planning, organizing, leading, and...

What is a functional currency? What do you think a non-functional currency would be?

Design a minimum-mass symmetric three-bar truss (the area of member 1 and that of member 3 are the same) to support a load P, as was shown in Fig. 2.9. The following notation may be used: Pu = P cos...

7. What should we interpret from this analysis? a) High blood pressure is significantly more common in males than females b) Males have lower rates of high blood pressure than females c) There is no...

8. How might the effect size of the relationship be measured? a) By how strongly the researcher feels about the project b) By the 2 of 7.77 c) By the degrees of freedom (1) d) By the Cramers V (.09)...

14. What are the expected frequencies for each day, under the null hypothesis that doctors do not have a preference? These results are from a fictional study examining whether Accident and Emergency...