locked
How to add a total column in column chart? RRS feed

  • Question

  • 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

    How should I do? Thanks!
    Thursday, February 5, 2009 8:15 AM

Answers

  •  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.

    -Sean


    Program Manager, SQL Server Reporting Services
    Thursday, February 5, 2009 6:16 PM