Previous SUM YTD not working -
10-28-2005
, 05:25 PM
I have try all of this format to get a Sum of YTD for the previous or
ParallelPeriod.
My problem is that when I select a Month or a Quarter , the sum between then
is not carried, on other If I select Feb 2005, it should sum Jan plus Feb
2005 and display it, but it does not becuause I use [Time].[Year]
Please help
sum(PeriodsToDate([Time].[Year],[Time].Currentmember.PrevMember),
[Measures].[Actual Revenue])
--Aggregate(OpeningPeriod(Time.CurrentMember.level,A ncestor(Time.CurrentMember,Year)):Time.CurrentMemb er,[Measures].[Actual Revenue])
--sum([Measures].[Actual Revenue],Time.PrevMember)
--([Measures].[Actual Revenue],ClosingPeriod([Time].[Year],Ancestor
([Time].CurrentMember,Year).PrevMember))
--sum(PeriodsToDate([Time].[Year],Ancestor
([Time].CurrentMember,Year).PrevMember), [Measures].[Actual Revenue])
--Sum(ClosingPeriod([Time].[Year],[Time].currentmember),[Measures].[Actual
Revenue]) |