Charting table detail and sum

Hot Topic

Resolving
How can I get or set a foreign key's 'on update cascade' or 'on insert cascade' by SQLDMO?
Calendar slow to load
XML Source - Generated XSD or XML Problem?
How to present distribution in percentage in pie chart?
cannot install samples
Backup devices (named pipes)
Changing Connection string in multiple packages.
Run entire package
Visual Studio 2005 Profession Edition

SQL Server

Back-up DB but keep the files for 3 days?
How do you process AS objects from the command-line?
memory management
x64 Opteron running SQL Server 2005 in 32-bit?
How to set an action?
Execute a SSIS master package through an ASP.NET web app
diploying reports on browser with custom assembly
Deferred Updates versus In-Place Updates
semicolon terminator
PredictSupport

Charting table detail and sum

I have a bar chart that displays the detail of a table with locations along the x-axis and number of employees on the y-axis. Is there any way to have the sum of all of the locations show as the final bar in the chart  (which would be the footer in the table)

Any help would be most appreciated,
Thanks




Answer this question

Charting table detail and sum

  • karabadji

    Just wondering if total chart bar are still not supported I need that also...

  • Saurabh.Garg

    Sorry, "subtotals" are not directly supported in charts. But I'm not sure if you would really get the desired effect with a subtotal in charts. Since the individual employee groups share the same Y-axis as the total number of employees, you would most likely get many small bars and one long bar showing the total number of employees.
    One alternative way is to add a second chart which just shows the total number of employees.

    -- Robert

  • Charting table detail and sum
Answer this question