It is certainly one way to display the total but bar chart with Grand total does not look good. Is there any way to capture the 10 without the extra bar?
In that case I think cumulative sum functional will and it can be shown on the last bar.
please see the attached
it returns this
the percent of total is
and the total is
to get the view you need to use the analysis tab total and dual axis - you can change the scale on the axis as you see fit
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
percent of total.twbx 13.3 KB