The actual problem is a lot more complex than what I am asking now; but on the first step to solve the problem; I am stuck. Could anyone suggest any idea?
Typical problem (as I have searched this form). I have a dimension called and then . A main order could have more than 1 sub orders. All I need to do is to count the number of for each .
I tried to use “ForEach” formula (as in the title above) but the result always show as 1.
Geez… That’s the answer? I see the function “Count <> IN <>” before in this forum; but I was thinking that it should not be the case. “ForEach” sounds more logical to me.
Why don’t I do this in the Universe? Because I don’t have access to this; just an end-user in my case; have no idea at all about the universe.
Did u try the CountAll function --counts all duplicates also,
CountAll ForEach
count will take only distinct values only thats why ur getin 1 only for Main.
try the above