"All Series" Line in Line Chart?

[ZenRaven]

I apologize if I confuse the terminology...

I've got a proc that returns an aggregated value grouped by week and day like this

Week Day Value
1 1 5
1 2 6
1 3 8
2 1 7
2 2 9
2 3 4

I've created a line chart with my limited SSRS knowledge and I've got it displaying the week on X-axis, Value on Y-axis, and each day group as a series.

My question is: How do I get the chart to show an additional series line for the lotal of all series lines regardless of day?

I get that line when I remove the series definition so shouldn't I be able to get that line in addition to the series breakdown?


--Adam
--"He who knows best knows how little he knows." - Thomas Jefferson

 

[ZenRaven]

I added a union into my proc to return the 2 different levels of aggregation in 1 result set


--Adam
--"He who knows best knows how little he knows." - Thomas Jefferson