I want to calculate running total of my measures.I used SUM(YTD([Date].[YEAR].CurrentMember), [Measures].[ProfileCreated]) It gives a right result within same year but when a new year starts its starts with 0.I want to calculate previous year data too. How can I do?
Dimension: Date-> default->Year->Month->Day