There are two expressions and one dimension in my bar graph. Is it possible to show a single bar at the end which calculates and displays the TOTAL for one expression and doesn't display for the other expression?
I would like to see something like in attached picture (Totals).
If not, is it at least possible to show TOTAL for just red bar and neglect the one that has constant values through out (as in picture, Totals2)?
I have tried that, if I enable "Show Total" option, then it would calculate total for both expressions and then display total for both blue and red bars which I don't want. I would just like to see the sum calculated for the red bar expression and not for the blue bar. For blue bar, the value is constant and I would like to keep that same value in totals as well. Is that possible?
Yes, this is a possible solution. But the only problem is, as the scale increases, length of other bars are reduced. I will check if I can change this. Will wait for few more replies and see. Anyways thank you for your suggestion and quick response.