Add Subtotal Lines to Chart

• dean gross

  SSCrazy

  Points: 2632

  More actions

  March 4, 2008 at 8:00 am

  #183453

  I have a line chart that plots hours vs dates and there are currently 6 categories of hours so I have 6 lines on the chart. I would like to be able to hide categories 1,2, and 3 and add a new line that shows the sum of categories 1,2, and 3. Any ideas on how to do this? do I need to change by sproc that returns the data or can I do this in the Report? using SSRS 2005

  Thanks

  Dean

• nigel.c.west

  Hall of Fame

  Points: 3468

  More actions

  March 17, 2008 at 10:50 am

  #790440

  I would have thought this one was reasonably simple to do unless I am misunderstanding something. To not show categories 1,2 & 3 just remove them from the chart. To include a sum of category 1,2 & 3 add another category to the chart which is formed from an expression which is Fields!Category1.Value + Fields!Category2.Value + Fields!Category3.Value

  This is very simple so I apologise if I have misunderstood something and told you what you already know. If this is the case, provide a bit more information on the problem and I'll see what I can do to help.

  Good luck,

  Nigel.

  Nigel West
  UK