Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Previos period YTD for closed periods only

Unanswered Previos period YTD for closed periods only

  • Friday, July 21, 2006 8:27 PM
     
     
    Sign In to Vote
    0

    I used the following to show YTD sales (it works fine)

         Sum(PeriodsToDate([Time].[Fiscal].[Fiscal Year]),[Total Dollars])

    I also created the following to get YTD for previous years (Quaters, months)

    FY-1 Sales:       ([Measures].[FY YTD Sales], PARALLELPERIOD([Time].[Fiscal].[Fiscal Year]))
    FY-2 Sales:       ([Measures].[FY YTD Sales], PARALLELPERIOD([Time].[Fiscal].[Fiscal Year], 2))

    These work fine also however I am concerened that I need to keep explaining that since the current quarter is not complete the number is lower for this year than last year.

    Is there a better way to do this that would only include previos years data up to this "day of year"

    Another choice may be not to include incomplete periods.  While not as desireable as the first mehtod, is there a way to do this?

    Thanks,

    Chris