Hi Martin,

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

Year :2010

JanFebMarchAprilAvg(last2 months)

Account

Sub Acc11212(2-1)=1

Sub Acc221110

Account2

Sub Acc233110

Sub Acc14413

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.

Thanks

Devi