0

My client has a standard report which shows monthly figures for various sales, enquiries etc. The report shows all months since the start of the contract (about three years ago, but growing by 1 every month!). The last row in the Tablix shows the totals (essentially the sum of all cells in that column above).

They have asked me to introduce another couple of rows, showing Year To Date values, for totals and monthly averages. I feel sure that there must be a way to do this simply (essentially it is the SUM or AVG of the last 12 rows in the Tablix), probably through grouping, but I just can't get my head around it.

Edwardo
  • 872
  • 1
  • 11
  • 24
  • http://social.msdn.microsoft.com/Forums/sqlserver/en-US/0b21bab0-ff02-4655-a69c-efedfb2a7077/top-n-report-total-row-not-correct?forum=sqlreportingservices – Tab Alleman Oct 01 '14 at 13:58
  • That answers a different question. My report shows all monthly figures for, say, the last 36 months, with a total for all 36 months, but it needs also a total for the last 12 months as well. – Edwardo Oct 02 '14 at 10:12
  • The method used can be applied to your problem. You essentially need to do a filtered total. Total the rows filtered by whether they occur in the last 12 months. Your filter is different from the one in the example, but the concept is the same. – Tab Alleman Oct 02 '14 at 13:21

0 Answers0