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

Request clarification before answering.
I don't know at all what to use. I think I don't express myself well To put it simply, I want to have the sum of the effective projects by Fact.Code heading So for the Fact.Code heading = 2 I must get 1000 For the Fact.Code = 69 I must get 0
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.