企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 820|回复: 2

Top Hirerchy level needs to aggregate

[复制链接]

84

主题

404

帖子

593

积分

高级会员

Rank: 4

积分
593
QQ
发表于 2014-6-8 19:37:46 | 显示全部楼层 |阅读模式
Hi
I have two Measures.
X and Y
Y is having Amounts and X is Empty and new

AIM:
Y must have Values of X whose Product Attribute value is 1.
This Product attribute is assigned for C level Product Group.

So For All Product Groups who is having Attribute 1 Amount must is flown to Y Measure.

[Y Measure] = If Attr('Products', !PRoducts,'Amount Flag') =1 ,[X measure],Stet);

By above rule my Y measure is populated with amounts of product group whose attr is 1 .

ISSUE:

I need The Top leve of Product Group value (Attr =2) is showing zero
i want this TOp level of Y measure to be a aggregate value of values in Y mesure.
How can i do it..

Thanks..
回复

使用道具 举报

94

主题

397

帖子

609

积分

高级会员

Rank: 4

积分
609
QQ
发表于 2014-6-8 21:35:55 | 显示全部楼层
Do a search for "N:" and "C:" in the rules guide.

Martin
回复 支持 反对

使用道具 举报

57

主题

378

帖子

507

积分

高级会员

Rank: 4

积分
507
发表于 2014-6-8 23:04:24 | 显示全部楼层
Yes
Both C: and with out C: is same but when i use N: i dont get any data because Attribute value is 1 for only C: level Product Groups....

I need to pull X measure values at C: whose attr is 1 into Y measure

TOP level Hirerchy was having 0 attr as all then i changed it to 2 which is unique to TOP most level .
And tryin to use formula as

If attr of Product dim is 2 then apply no rule just aggregate all values in Y measure ------- this am not able to commplish
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|小黑屋|企业绩效管理网 ( 京ICP备14007298号   

GMT+8, 2022-9-30 10:37 , Processed in 0.058128 second(s), 16 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表