0 Replies Latest reply: May 14, 2014 9:35 AM by Daniel Fleisher RSS

    Stacked bar chart

    Daniel Fleisher

      I have a bar chart which is set to be stacked. However, I don't want it to stack to the sum of the 2 expressions.

      I'm using Total Sales, and then Profit. If I have Total Sales of 10,000 and profit of 3,500, I want to see 2 colors - one which ends at $3,500, and the other which goes from $3,500 to $5,000.

      I know I can change my formula for Total Sales to be sum([Total Sales]-Profit). I don't want to do that, because if someone exports the data to Excel, it will show Total Sales as only $1,500 instead of $5,000.

       

      Any ideas on how to accomplish this?