TM1 Forum

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..

Do a search for "N:" and "C:" in the rules guide.

Martin

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