Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
WITH
MEMBER [Measures].[Current Year Jan-Feb Sales]
AS SUM(
({[Date].[Month Of Year].&[1], [Date].[Month Of Year].&[2]},
StrToMember('[Date].[Year].&[' + CSTR(YEAR(NOW())) + ']')),
[Measures].[Sales Amount])
MEMBER [Measures].[Current Year Mar-Apr Sales]
AS SUM(
({[Date].[Month Of Year].&[3], [Date].[Month Of Year].&[4]},
StrToMember('[Date].[Year].&[' + CSTR(YEAR(NOW())) + ']')),
[Measures].[Sales Amount])
SELECT {[Measures].[Current Year Jan-Feb Sales] , [Measures].[Current Year Mar-Apr Sales] } ON 0
FROM [Your Cube]