- Home
- Anonymous
- Sign in
- Create
- Ask a question
- Spaces
- Site Issues (NOT FOR DATABASE QUESTIONS)
- Explore
- Topics
- Questions
- Users
- Badges

I have a matrix report and at the end i have two calcs. Avg of 12 months and Sum of 12 months - no big deal... - it's a so Rolling Month 12, 11, 10, 9 ~1 How can I calculate the most recent month / Average Sales using a matrix report.... The underlying db is using sql 2000 If YRMonth = MaxYearMonth = Then Average/Max(YearMonth) I've tried =Avg(Fields!Sales.value)/SUM(IIF(Fields!Month.value=MAX(Fields!Month.value),Fields!Sales.value,0)) with no luck. Thanks... SSRS 2008 R2

ssrscalculationsmatrix
Comment

**14** People are following this question.

Copyright 2019 Redgate Software.
Privacy Policy