dbTalk Databases Forums  

Previous SUM YTD not working

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Previous SUM YTD not working in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tomas
 
Posts: n/a

Default 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])


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.