Hello,
I added a calculated measure into a cube which calculated the increase (or decrease) of an amount in comparision to the pre-period.

The calculation is correct, but in the Excel Pivot Table any filters applied in the page line are ignored. If I use the filter as a dimension on the axis of the pivot table and select the filter there then it also works fine.

I have AS SP3 installed and use Office XP.

The calculated measure works like this:

iif(isempty(([PostingPeriod].CurrentMember.Prevmember,[Measures].[Amount])),0,([PostingPeriod].CurrentMember,[Measures].[Amount])*100/([PostingPeriod].CurrentMember.Prevmember,[Measures].[Amount])-100)

Thanks.