Avatar

Level 1

I'm looking for some help in getting counts for records in Campaign.  I have an external transactions database that I'm querying as the target and filtering dimension.  Within the table is a field (MemberID) that can be duplicated across multiple transactions, so after I have the transactions returned that i'm looking for, I want to have a count of the number of times the Member ID appears.  Example:

TransactionID (Key)MemberID
111111
222222
311111
422222
533333

 

I want to get a count of the number of times the MemberID appears, but I'm having issues because the MemberID is not a key.  I have no problem doing counts other times with counts related to the table keys, but I'm lost on this one.  I'm looking for results like:

 

Member IDCount of MemberID
111112
222222
333331

 

Any help would be greatly appreciated.