my current datasource is SSAS, the data set format likes:
Name Count Month A 3 1 A 6 2 B 1 1 B 2 2
The Name row is dynamic.
The report x-axis is Month, y-axis is Count, Series field is Name, the chart now shows each person's count/month, I want to add a total count column (A count + B Count) for each month, likes:
Name Count Month
A 3 1
A 6 2
B 1 1
B 2 2 Total 4 1 Total 8 2
I would recommend just using a stacked column chart. Each month's bar will be divided into two segments on that bar, and the total height of that bar will be the sum of the counts.