摘要: WITH MEMBER [Measures].[销售台次当月计划] AS ([日期].[年-月-日].parent,([目标类型].[目标类型名称].&[财务精品收入],[Measures].[门店月目标值]))MEMBER [Measures].[本月收入] AS iif(sum(mtd([日期].[年-月-日]),(iif([Measures].[财务精品收入]=null,0,[Measures].[财务精品收入])))=0,null,sum(mtd([日期].[年-月-日]),(iif([Measures].[财务精品收入]=null,0,[Measures].[财务精品收入]) 阅读全文
posted @ 2011-02-23 10:12 emmy 阅读(315) 评论(0) 推荐(1) 编辑