Report Portal

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..

 

2007-2015 VidasSoft Systems Inc.