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