Question: Create a Bar chart to show Total Profits by Sub-categories (must use Hierarchy to display both Categories and Sub-categories) in the year 2013 . Display

  1. Create a Bar chart to show Total Profits by Sub-categories (must use Hierarchy to display both Categories and Sub-categories) in the year 2013.
    • Display Total Profits on each bar (in dollars)
    • Create a parameter to control a threshold value, called threshold": use Integer with $ 20,000 as Current Value, $80,000 as Maximum, and $5,000 as Step value
    • Create a calculated field, named profits for subcategory, where the following rule is used: iftotal profits is over "threshold,"you need to label it High Profits; otherwise, label it as Low Profits.
    • Show a parameter control on side

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!