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: 1) A tree map with size representing order quantity. 2) 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. 3) 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 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 Programming Questions!