Hello,


I seem to be having some problems with a Period to Date measure. What I want is a running total from the beginning of time to the time period the end user selects. Thus it is a running value that doesn't reset for years/quarters or any other level.


My calculation in Analysis Services 2000 worked perfectly and is:


Sum(Periodstodate([Period].[(All)]),[Measures].[Sales])


In AS2005 my heirarchy has changed and is reflected below in the mdx:


Sum(PeriodsToDate([Period].[Period].[(All)]), [Measures].[Wipdisb])


What am I doing wrong? Why in AS2005 does it not keep cumulating?


Thanks in advance