This may sound a little silly, but I can't quite figure out how to create a script from the MDX Below:
With
Member [Measures].[CustCount] As
Count(
Filter(
Existing {[Sell-to Customer].[Customer].Members},
([Measures].[Sales Amount] >0)
) * {[Measures].[Sales Amount]}, EXCLUDEEMPTY
)
SELECT
{
([Measures].[CustCount])
} On Columns,
{[Sell-to Customer].[by Country by City].[Country].Members} On Rows
From
[Sales]
It should be simple, but i'm missing something!
Any assistance would be helpful
regards Chris