Parallelperiod: what I am not understanding

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello,

I have an issue with the parallelperiod function. I created a calculated member on the cube called Previous Year Turnover and this is my calculation of the parallelperiod:

(PARALLELPERIOD([Invoice Date].[Year - Quarter - Month - Date].[Year],1,[Invoice Date].[Year - Quarter - Month - Date].currentmember),[measures].turnover)

If I compare for example the whole 2007 against the whole 2006 everything is fine and I have a result like that:

2007 100
P.Y. 98

If I want to compare just the first 6 months the result is like that:

2007 50
P.Y. 98

If I drill down by Quarter I have the correct results for the quarter and the correct one if I continue to drill down.

What I would like to achieve is the following result:

2007 50
P.Y. 48

Is there any simple way to do that? I want the user to be able to select just the months that he want to see and have the comulated value for the year compared with the same period of previous year without the need to go down to quarter level or month level. Using Excel with the pivot table this seems impossible.

Thanks a lot for the help!

Andrea Pagliano

.