Aggregate series in line chart

• thetodaisies

  Ten Centuries

  Points: 1387

  More actions

  September 17, 2009 at 3:50 am

  #204697

  Hi,

  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

  Jan--Status1--10

  Jan--Status2--15

  Feb--Status1--20

  Feb--Status2--25

  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

  Thanks

• nicole.hulst

  Grasshopper

  Points: 13

  More actions

  May 27, 2013 at 9:04 am

  #1618801

  Hello,

  I have the same question. Have you ever found a solution?

  Thanks, Nicole