0

Creating Script from MDX

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

 

0 comments

Please sign in to leave a comment.