I have a dim design and data as follows.
Dim
Group_1
Tier_1
Child_1
Child_22
Tier_2
Child_1
Child_45
What I need is to be able to do a distinct count at the Teir or Group level of the Child level members. I am currently using
a Calculated Member with the formula as follows...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.