1.

How Do I Find The Bottom 10 Customers With The Lowest Sales In 2003 That Were Not Null?

Answer»

SIMPLY USING bottomcount will return customers with null SALES. You will have to combine it with NONEMPTY or FILTER.

SELECT { [Measures].[Internet Sales Amount] } ON COLUMNS , BOTTOMCOUNT( NONEMPTY(DESCENDANTS( [Customer].[Customer Geography].[All Customers] , [Customer].[Customer Geography].[Customer] ) , ( [Measures].[Internet Sales Amount] ) ) , 10 , ( [Measures].[Internet Sales Amount] ) ) ON ROWS FROM [Adventure Works] WHERE ( [DATE].[Calendar].[Calendar Year].&[2003] ) ;

Simply using bottomcount will return customers with null sales. You will have to combine it with NONEMPTY or FILTER.


Discussion

No Comment Found

Related InterviewSolutions