Posted - 10/09/2013 : 13:08:04
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.
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..