I want to setup a calculated member that is the corresponding financial figure for the previous year. The time dimension is [Month Closed] and it has 3 levels: [Year Closed], [Quarter Closed], and [Month Closed]. I'm using this statement:
(ParallelPeriod([Month Closed].[Year Closed]),[Measures].[Actual Price])
I have figures in the following periods:
Q2 - 2002
Q1 - 2003
When viewing from the year level, OK!
When viewing from the quarter level, it matches the Q1 figures in 2003 to Q2 in 2002 which is of course not right but I guess it does this because this is the first "whatever" it hits within the 2002 year to match to the first "whatever" it hits within the 2003 year.
Make sense? Anyway to fix this?
(ParallelPeriod([Month Closed].[Year Closed]),[Measures].[Actual Price])
I have figures in the following periods:
Q2 - 2002
Q1 - 2003
When viewing from the year level, OK!
When viewing from the quarter level, it matches the Q1 figures in 2003 to Q2 in 2002 which is of course not right but I guess it does this because this is the first "whatever" it hits within the 2002 year to match to the first "whatever" it hits within the 2003 year.
Make sense? Anyway to fix this?