Income Statement Waterfall Chart with Gross Margin breakdown

[pratibhatiwari]

Hi,

I am trying to create a waterfall chart for income-statement to show the breakdown from Gross Sales to Net-Income and display Gross-Margin as a subtotal (not increase/decrease).

Gross Margin = Gross Sales - Cost of goods sold and other expenses

Net Income = Gross Margin - Wage and Direct expenses - Other Indirect and Other expenses.

Net income should be displayed as total and should be -0.2M

However, having Gross Margin as a positive value here increases the total value.

I tried subtracting the Gross Margin after I added it (Gross Margin - ot), I get the correct total for net income but now I have 2 bars for Gross Margin. 

Is there a way I can show Gross Margin as sub-total in the first image ?

or hide a bar from visual in the second image ?