SSRS 2008 R2 - Add total line to chart

I have created a line chart tha开发者_如何学运维t displays the different types of messages sent over a month (Email, Print, Voice) which are displaying on the chart just fine.

Is there an easy way to add another line which totals the values for the 3 series without changing the SQL?

---

There are two way to do this in reporting services:

1. Directly in the chart

Add a new series to your line chart. Set the expression for the value to be

=Fields!Email.Value + Fields!Print.Value + Fields!Voice.Value

2. With a calculated field in the dataset

Set the calculated field "AllMessages" to be the sum of Email, Print and Voice. Then add AllMessages to your chart. Youtube Walkthrough calculated field