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
Quote from: inu on 19 Mar 2017 12:49:59 PM
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.
Quote from: MFGF on 21 Mar 2017 09:38:34 AM
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 from: inu
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
/quote]
Quote from: inu on 22 Mar 2017 01:53:23 AM
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