Solved

SSRS add total sums of series to the legend

Posted on 2011-09-15
5
2,889 Views
Last Modified: 2012-05-12
How can I add the total sums of series to the legend on my chart? ChartExample.docx
0
Comment
Question by:jaymz69
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
5 Comments
 
LVL 17

Expert Comment

by:dbaSQL
ID: 36545252
you should be able to adjust the dataset in order to return the sum total.  add a 'totals' row, and then it just flows through to the chart
0
 
LVL 17

Expert Comment

by:dbaSQL
ID: 36545263
0
 

Author Comment

by:jaymz69
ID: 36545299
I want a grand total fot t_cnt and one for s_cnt
0
 
LVL 17

Expert Comment

by:dbaSQL
ID: 36545373
Right click your fields, select "Add Total". This will create a new footer row, and you can manipulate it to return the grand total.
0
 
LVL 17

Accepted Solution

by:
dbaSQL earned 500 total points
ID: 36545379
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Add a step to a system backup job 6 36
Amazon RDS migrate to SQL Server 3 34
query optimization 6 22
the way to learn Microsoft BI 13 50
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question