Skip to Content
0
Former Member
Oct 27, 2009 at 09:06 PM

Count 'if ID = x'

116 Views

I have a data provider like this:

OID ID

21 89

23 89

24 12

Where OID is unique.

I want to have a count variable that counts by ID type, so the resulting table would be this:

ID Count

89 2

12 1

What variable do I create?

I have tried:

=count(<OID>) where ID=12

but this doesnt seem to work.....