ORDER语法如下:
Order(«Set», {«String Expression» | «Numeric Expression»} [, ASC | DESC | BASC | BDESC])
示例:
select NON EMPTY {[Measures].[user_count]} ON COLUMNS,
NON EMPTY Order(Hierarchize(Union({[channel].[All channels]}, [channel].[All channels].Children)), [Measures].[user_count], DESC) ON ROWS
from [install]
mondrian按指标排序
最新推荐文章于 2018-02-03 15:16:56 发布