Hi all,

I’ve created a calculated member giving the percentage of number of items (named PBP) compared to the All level of a dimension:

([Status].CurrentMember,[Measures].[Number of PBP])/([All Status], [Measures].[Number of PBP])

I would like to use this calculated measure in an Excel Pivottable with the Status dimension as rows like following:

Status Percent of PBP
Status 1 42%
Status 2 4%
Status 3 2%
Status 4 4%
Status 5 25%
Status 6 23%
Grand Total 100%

The problem is that when I filter the Status values choosing Status 1 not to be displayed, for example, the ([All Status], [Measures].[Number of PBP])
Is calculated in function of the Statuses that are displayed, without taking into account the Status 1 value:

Status Percent of PBP
Status 2 7%
Status 3 4%
Status 4 7%
Status 5 43%
Status 6 39%
Grand Total 100%

… while I would like:

Status Percent of PBP
Status 2 4%
Status 3 2%
Status 4 4%
Status 5 25%
Status 6 23%
Grand Total 58%

So does anyone know how to get the ‘All level’ value independent of the members that are selected?

Thanks for answering as quickly as possible.

Cedric.