Skip to main content

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


 

Be the first to reply!

Reply