KB221881: How to create bar graph with opposite directions sharing one Y axis in MicroStrategy Web 9.4.1

With one attribute and 4 metrics, how to create a graph with opposite directions like below?

ACTIONS:

• Create dataset containing Year, Cost, Profit, Revenue and Profit Margin

• Create a document with 2 graphs: Profit-Revenue-Year and Cost-Profit Margin-Year.

• Create derived elements for metrics to be in opposite direction: Cost and Profit Margin

• Replace the left graph metrics with newly created negative metrics.

• Change negative value format in editable mode and make the values format as custom “$#,##0”:

• Uncheck "Show labels for this Axis" for Category in left graph.

• Hide both graph titles if necessary.

• Adjust alignment and run in flash mode