I need help with a Set Analysis formula. In this example I have a dimension in the Display table that I am trying to get a count within the Detail table about how many exist. I can get the count if I hard code the codes and is shown in the text objects. In the straight table I can use the Only function to get the dimension Code but inserting into a Set Analysis expression the correct answer does not appear.
Can anyone figure out how I can make my counts come out correctly?