Add Subtotal Lines to Chart

  • dean gross

    SSCrazy

    Points: 2632

    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: 3418

    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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply