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?