I have a SSRS chart which is plotted using 3 fields X - Month,Y - Status, Count. Now this gives Count for the given month and Status.
for this data
Added months as Category
Added Status as Series
Added Value as Sum(Count)
so chart wil have 2 lines for Status1 and Status2
now i want a third line(Series) which is sum of Status1 and Status2.
ie. for Jan i will have Status1 point 10 Status2 point 15 and StatusSum point 25
Please give any ideas. Hope the above description is understandable
I can do it by removing the series and hardcoding each Status. but the count of Status is variable