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
- 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
