Sorry, I didn't saw your previous reply when I public my last post.

So I have to use an MDX function like periodsToDate in my connection formula? Is it possible using...

look at this:

I have use this connection formula:

In Calendar 2011 (green cell) I have the right value (function "year"), but in Calendar 2011 to Date by Day (red cell)...

In BusinessIntelligence development studio and in excel the scope statement work fine.

It work fine in PPoint without any filter, but when I add a post formula filter and I put...

[Measures].[Values] properties:

AggregateFunction:SUM

DataType:Double

FormatString:#,##0.00

I wrote an mdx script to overwrite measure value on year level:

SCOPE ([Measures].[Values]);

this=

(case when

[Calendar].[Year - month - day].level.name='year'

then

AVG( [Calendar].[Year - month - day].currentmember.children,[Measures].[Values])

else

([Dim Performance].[Performance].currentmember,[Measures].[Values])

end);

End...

I'm using PPoint 2010.

I created a Time Intelligence Post Formula Filters.

I hooked the filter to an analytic grid (source value="member UniqueName").

I wrote this connection formula:

See the image to understand...

Hi, thank for repling.

I've tried yeartodate function, but it give me the sum of the month even if in the cube i have a mdx scope that calculated the average...