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: