Wanted to check possibility of below requirement.
I have 2 measures(Cost and Sales) and 1 dimension(Item number), as below.
I have 2 items and their cost, sales values. Opportunity values and Future Scope are calculated values as below
Opportunity value=some margin $
Future = sales+Opportunity value
|Item number||Cost||Sales||Opportunity value||Future Scope|
Can we create a bar chart to display cost, sales and opportunity value as attached in png.
thanks in advance for help.