Merged dimension calculation problem

[#1]

Hello I have a merged dimension called "Proj.code project" (2nd line of the table)

I want to add up each "Item Code Fact." (1st column left) f

or any project code I want to get the table found on the right.

However the second column from the left is a merged dimension and I think this is problematic in my formulas

[ju_mia]

I want to have only the table on the right, that is to say the column Fact.Code heading and the sum of effective proj.

My issue is the following : I have the left table with 4 columns:

• Icode factor Project (column 1)
• Project code (merged dimension) ==> Column 2
• Proj.Effectif (Column 3)

I wish to have the sum of the Effective Project for each Item Code Factor

Example: For the item code = 2, the sum of the effective projects is equal to 1000

So I tried the following formula: Sum [(Effective Project)] ForAll([Item Code Factor])

but it gives me the result 1,050 on all the rows of the table.

I don't know if I was clear ?