Set Analysis with Dimension as Lookup

[bob_zagars]

Hi,

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?

Thanks in advance,

Bob

[maxgro]

maybe

Count(DISTINCT if(Item=Code, [Acct Number]))

[bob_zagars]

Maxgo,

Thanks that works but I figure there is a Set Analysis solution.

Bob