Hi,
you could either created a calculated measure (as you requested)
with
set Sam as {
[Customer].[Customer Code].[Sam1],
[Customer].[Customer Code].[Sam2],
[Customer].[Customer Code].[Sam3]
}
member [measures].[sales ex sam] as
sum(
except(
[Customer].[Customer Code].members,
Sam
),
[Measures].[sales]
)
select {[measures].[sales ex sam]} on columns
from [your cube];
or do a simple select on your sales measures excluding customers with a sam code
with
set Sam as {
[Customer].[Customer Code].[Sam1],
[Customer].[Customer Code].[Sam2],
[Customer].[Customer Code].[Sam3]
}
select {[Measures].[sales]} on columns
from [your cube]
where
except(
[Customer].[Customer Code].members,
Sam
);