594
社区成员
发帖
与我相关
我的任务
分享
查出最近6个月销售趋势最好的前10个商品及其各自销售量
withset [TenBest] as 'TopCount( [Product].[Brand Name].Members, 10, [Unit Sales] )'
set [LastMonth] as 'Tail(Filter([Time].[Month].Members, NotIsEmpty([Time].CurrentMember)),1)'
set [Last6Months] as ' [LastMonth].item(0).item(0).Lag(6) : [LastMonth].item(0).item(0)'
select [Last6Months] onCOLUMNS,
[TenBest] onROWS
from Sales
找出组成销售额80%的商品销售及其记录;
select {[Unit Sales]} onCOLUMNS,
TopPercent([Product].[Brand Name].Members, 80, [Unit Sales]) onROWS
from Sales
按销售量排序,找出组成20%销售量的商品销售记录
select {[Unit Sales]} onCOLUMNS,
NonEmptyBottomPercent([Product].[Brand Name].Members, 20, [Unit Sales]) onROWS
from Sales
查出销售量最好的前5名店和每个店的前5个顾客及其销售记录
select {[Unit Sales]} onCOLUMNS,
Generate( TopCount([Store].[Store Name].Members, 5, [Unit Sales]),
{ [Store].CurrentMember } * TopCount( [Customers].[Name].Members, 5, ([Unit Sales],
[Store].CurrentMember) ) ) onROWS
from Sales