Hi, I have a set of data, that I have cascaded to show a cumulative representation on a line chart (i.e. the values building up over time). However, when you add on the data labels, it shows the non-cumulative values on the chart - is there a way of changing this around?
Also, I don't really want to show all the data labels, just the last value. I have seen some charts where this has been done and wondered if we can do this?
The idea is that you will see the individual values on top of the bars, and read the cumulative value on the axis. If you wish to display just the last cumulative value you can tick the Stats option under the Measures, then tick Sum, as per screenshot below.
Thanks for this, perfect, is there anyway when using the Stat functions you can edit where it appears on the chart? It would be good to have it at the end of the chart (i.e. in your diagram to the Right of the last bar)?