Cannot create a summary field using a relationship where the reference field is a lookup field.

Yes, it�s too bad that you can�t use a Snapchat filter. You will need to use an automation or an action to copy the value of the look up field into another field and use that second field for the relationship.