Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BigBolts
Starting Member
5 Posts |
 Posted - 2012-01-12 : 13:17:06
|
Hi All, My dataset returns Year, Month and count from the database:SELECT YEAR(date) AS [Year], MONTH(date) AS [Month], COUNT(id) AS [Count] FROM tableGROUP BY YEAR(date), MONTH(date)ORDER BY YEAR(date), MONTH(date)My chart shows Year, Month breakdown of count and then uses runningvalue to get cumulative year to date.  I'd like to show the previous year to date for comparison, I have the data in the dataset and have tried to use the scope of runningvalue to show the right year, but I can't find a way to get it working. Anybody get any ideas?Thanks. |
|
|
|
|
|
ssrs2008r2 chart with multiple YTD