I need to calculate Inception To Date (I
		
 I need to calculate Inception To Date (ITD) measure, just like the YTD but this one will span over multiple years. My Date dimension has a hierarchy like this..Calendar Year, Calendar Quarter,Calendar Month..and I tried to use the PeriodsToDate function, but its telling me, I used member expression instead of level expression..
Below gives me YTD amount...
Aggregate
(
  PeriodsToDate
  (
     [AC Period].[AC Period Hierarchy].[Calendar Year],
	 [AC Period].[AC Period Hierarchy].CurrentMember
  ),
  [Measures].[Gross Actual Amount]
)
And I tried..for ITD amount
Aggregate
(
  PeriodsToDate
  (
     [AC Period].[AC Period Hierarchy].[All],
	 [AC Period].[AC Period Hierarchy].CurrentMember
  ),
  [Measures].[Gross Actual Amount]
)
I appreciate your help in advance..	
	
	
	
	
		
	
	
