Member: Revenue Recognition Amount CYTD
CREATE MEMBER CURRENTCUBE.[MEASURES].[Revenue Recognition Amount CYTD]
AS NULL,
FORMAT_STRING = "Currency",
NON_EMPTY_BEHAVIOR = {[MEASURES].[Revenue Recognition Amount]},
VISIBLE = 1 , DISPLAY_FOLDER = 'Calendar Year To Date' , ASSOCIATED_MEASURE_GROUP = 'Revenue Recognition';
(
[Date].[Calendar Year].[Calendar Year].MEMBERS
,[Date].[Calendar Date].MEMBERS
,[MEASURES].[Revenue Recognition Amount CYTD]
) =
Sum
(
PeriodsToDate
(
[Date].[Calendar Date].[Calendar Year]
,[Date].[Calendar Date].CurrentMember
)
,[MEASURES].[Revenue Recognition Amount]
);