TopCount ( set , index [,numeric_value_expression ] )
The set from which the top n elements are selected.
The number of elements to include in the set (n).
Optional. An expression further defining the selection criteria.
select
{ ([Calendar].[ALL].[2021]) } on 0,
topCount(crossjoin(members(measure), children([Store Type].[ALL]), lateralMembers([Payment Method].[ALL].Other)), 10, ([Calendar].[ALL].[2021])) on 1
from [Online Store] ;
| 2021 | |||
| sales amount | Platform Self-operated Store | Debit Card | 6061 |
| sales amount | Platform Self-operated Store | Account Balance | 6058 |
| sales amount | Brand Flagship Store | Credit Card | 6052 |
| sales amount | Platform Self-operated Store | Credit Card | 5985 |
| sales amount | Other | Debit Card | 5942 |
| sales amount | Other | Credit Card | 5686 |
| sales amount | Brand Flagship Store | Account Balance | 5572 |
| sales amount | Brand Flagship Store | Debit Card | 5333 |
| sales amount | Other | Account Balance | 5270 |
| sales quantity | Brand Flagship Store | Credit Card | 5113 |