I have a bar chart which is stacked, I need to add a line which should show the Total for the stack. But when I add a line to a combo chart the stack features does not remain & becomes grouped. What should I do to show them as stacked with a total line for each stack bar only.
I also tried with a split axis feature to show the line on the same axis left(bottom) but also the same thing is happening.
The expression that I used for the total is Count(Total value) like that. Please suggest what should I do? Thanks in advance.