Order ( set, string_expr | numeric_value_expression [,BASC | BDESC] )
The set to sort.
String sorting criteria.
Numeric sorting criteria.
If this keyword is used, the returned set is arranged in ascending order. Ascending order is the default even if no keyword is used.
If this keyword is used, the returned set is arranged in descending order.
select
order(members(Calendar), (measure.[sales amount])) on 10,
{ (measure.[sales amount]) } on 1
from [Online Store] ;
| sales amount | |
| 2019 | 0 |
| Q1 | 0 |
| M1 | 0 |
| M2 | 0 |
| M3 | 0 |
| Q2 | 0 |
| M4 | 0 |
| M5 | 0 |
| M6 | 0 |
| Q3 | 0 |
| M7 | 0 |
| M8 | 0 |
| M9 | 0 |
| Q4 | 0 |
| M10 | 0 |
| M11 | 0 |
| M12 | 0 |
| M1 | 1440 |
| M2 | 1440 |
| M3 | 1440 |
| M4 | 1440 |
| M5 | 1440 |
| M6 | 1440 |
| M1 | 1440 |
| M2 | 1440 |
| M3 | 1440 |
| M4 | 1440 |
| M5 | 1440 |
| M6 | 1440 |
| Q1 | 4320 |
| Q2 | 4320 |
| Q1 | 4320 |
| Q2 | 4320 |
| M12 | 6793 |
| M11 | 7148 |
| M7 | 7238 |
| M10 | 7290 |
| M8 | 7359 |
| M9 | 7491 |
| Q4 | 21231 |
| Q3 | 22088 |
| 2021 | 51959 |
| M7 | 1440000 |
| M8 | 1440000 |
| M9 | 1440000 |
| M10 | 1440000 |
| M11 | 1440000 |
| M12 | 1440000 |
| Q3 | 4320000 |
| Q4 | 4320000 |
| 2020 | 8648640 |
| ALL | 8700599 |