Count most recent value with a rule

Hi, I'm trying to achieve the following table representation: For each Activity, count the number of IDs that are doing it in their most recent DateID. Important: there are duplicates, so keep onl...