Thanks for your input. this is really helpful. I am stuck with an issue and unable to find any information. Hope you can provide me with some suggestions.
My issues is
Data Source :SSAS
Report Type :Matrix (Drill Down)
I have a report
Jan Feb March April Avg(last2 months)
Sub Acc1 1 2 1 2 (2-1)=1
Sub Acc2 2 1 1 1 0
Sub Acc2 3 3 1 1 0
Sub Acc 1 4 4 1 3
I am able to create the report create totals , sub totals etc, my issue is the population or calculation of the last column “Avg” last column depends on the parameter (EndMonth), it is always EndDatevalue –EndDate-1.value.
Is there a way that I can get to that column
I tried to first display the last 2 columns but could not get to that. I tried
=IIF((Format(CDate(Fields!MonthFirst.Value), "yyyyMM"))=Parameters!ToDimDateYearMonth.Value,0,IIF(IsNothing((Fields!Orders.Value)), 0,(Fields!Orders.Value)))
Is there a way to get the last column.
Any suggestions are highly appreciated.