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 |
|
kishoremcp
Starting Member
41 Posts |
 Posted - 2013-10-09 : 13:08:04
|
| Hi, I have 13 months data in a table. Rows(Months) and 6 Fields in Column. I am having 12 months average using the below expression. =(Fields!ID12_Month_Average.Value)Here I am calculating the average in SQL Query. What I want is a sparkline which shows only last 12 months values. Average = sum(values)/12 where month key is between last month and last 12 months (Ex: Oct-12 to Sep-13). Is it possible in SSRS. If so please help me..RegardsKishore |
|
|
|
|
|
Spark line in SSRS