Hi

I have a small problem, I think.

I have my measures on the Columns and Systems (A,B,C) on Rows.
I have another dimension the shows Branch (1,2,3)

By default I have been showing some measures for all systems, either for all branches or just for one branch.
What I need to do now is show some measures for all systems for all the branches except one, i.e. 1+2 and exclude 3.

I´m not having much luck in finding a way do do this.

Note. Branches do not show on the grid. So I can´t simply use [Branch].[1]:[Branch].[2] or something like that.

thanks for any and all assistance

Arnar / Iceland

If anyone has the same problem.. here´s my solution

I created a set of the Branches that I need to include.
Then I create a member in the Branch dim that is the sum of all the members in the previously created set. i.e. sum([Branches])

Then its just a matter of setting the WHERE clause to this new member of the Branch dim.