Report Portal

How do I find the bottom 10 customers with the lowest sales in 2003 that were not null?

How do I find the bottom 10 customers with the lowest sales in 2003 that were not null?

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

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] ) ;

 

Result will be:

 Internet Sales Amount
Ariana Peterson$2.29
Olivia Brown$2.29
Abigail L. Bennett$2.29
Natalie L. Bryant$2.29
Madison D. Lee$2.29
Lauren Miller$2.29
Stephanie B. Murphy$2.29
Cameron L. Rodriguez$2.29
Melanie Peterson$2.29
Alfredo Romero$2.29

Done.

Tags: mdx, faq

 

2007-2015 VidasSoft Systems Inc.