Cacher is the code snippet organizer for pro developers

-- Running Total for Internet Order Count

-- [Note that {NULL:xxx} just creates a set 
-- of everything before the xxx member, i.e. everything to date]

WITH MEMBER [Measures].[Running Total]
AS
SUM ( { NULL:[Date].[Calendar].CurrentMember},
		[Measures].[Internet Order Count]
	)

SELECT {
		[Measures].[Internet Order Count],
		[Measures].[Running Total]} ON COLUMNS,
		[Date].[Calendar].[Calendar Year].MEMBERS ON ROWS
FROM [Adventure Works]

Linkedin Profile : https://www.linkedin.com/in/harshasannareddy/