Count 'if ID = x'

[Former Member]

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.....

[Former Member · Accepted solution]

Hi,

Try this formula =Count(<OID>) IN <ID>

Cheers,

Suresh A.