Question: Management is eager to know the most profitable subcategory per order. Add a new sheet titled Sales & Profitability by Order. Required Components: 1 )
Management is eager to know the most profitable subcategory per order. Add a new sheet titled Sales & Profitability by Order. Required Components: A tree map with size representing order quantity. Color the tree map using a calculated field of sum of profit divided by sum of order quantity, with the darkest color representing the highest profit per order. Add labels to the tree map representing each subcategory and total sales for each subcategory expressed as currency. Based on the data presented, which subcategory is the most profitable per order?
Answer This question with correct details.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
