Ytd calculation at report level using dmr model

[inu]

Hi Team,
I got the syntax for YTD .and understood the meaning as well as below
total( currentMeasure within set  periodsToDate ( [Sales (analysis)].[Time].[Time].[Year], [Current Month] )  )

except one thing that is
total( currentMeasure within set..
Is currentMemsure a function?
Then where I will put my own measure item
I didn't get this point.. Can you please put a light on it..


Thanx
Inam

[MFGF]

Hi Team,
I got the syntax for YTD .and understood the meaning as well as below
total( currentMeasure within set  periodsToDate ( [Sales (analysis)].[Time].[Time].[Year], [Current Month] )  )

except one thing that is
total( currentMeasure within set..
Is currentMemsure a function?
Then where I will put my own measure item
I didn't get this point.. Can you please put a light on it..


Thanx
Inam

Hi,

currentMeasure is referring to whatever measure is in context for the expression at that point in the processing. If your crosstab has only one default measure, it will always be this. If you have multiple nested measures, then the value will change as the crosstab iterates through each...

MF.

[inu]

Hi,

currentMeasure is referring to whatever measure is in context for the expression at that point in the processing. If your crosstab has only one default measure, it will always be this. If you have multiple nested measures, then the value will change as the crosstab iterates through each...

MF.

/quote]

[MFGF]

OK. Thanx MF.
Can I use the the above syntax in tuple function.
So that I will get measure value based on above timeframe.

Regards,
Inam

Yes