Solved

SSRS add total sums of series to the legend

Posted on 2011-09-15
5
2,721 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
  • 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

867 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now