Stacked bar chart total

[#1]

Hi community,

I am making a chart to analyse the proportion of discount to the sales

I want to set the total amount be sales and discount is included in the sales

However,the chart shows that the discount amount add up with the sales figure

How can i fix this problem and make discount included in total sales amount

[jmvilaplanap]

Hi

have you tried change to grouped?

[awhitfield]

May be like this?? Example with Gross Sales of 100 per item and 10 discount