Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Top 10 lowest product

Answered Top 10 lowest product

  • Tuesday, February 26, 2013 6:37 PM
     
      Has Code
    Sign In to Vote
    0
     
    TopCount
(
    [Product].[Product Name].[Product Name].Members,
    10,
    [Measures].[Internet Sales-Sales Amount]
)
    I need the lowest, how do I ORDER by ASC in this?
     

All Replies

  • Tuesday, February 26, 2013 8:14 PM
     
     Answered Has Code
    Sign In to Vote
    0

    Hi,

    there is a bottomcount function

    select [Measures].[Internet Sales Amount] on 0
,
bottomcount(
nonempty([Product].[Product].Members,[Measures].[Internet Sales Amount])
    ,10,
    [Measures].[Internet Sales Amount]
)
on 1
from [Adventure Works]

    HTH

    Joschko

    • Marked As Answer by K.Kalyan Tuesday, February 26, 2013 9:02 PM
    •