Count and filter multiple row values in one column with same unique ID in another column
I am having some difficulty effectively reporting (counting, filtering, etc) on unique IDs that have data listed in multiple rows in another column within a dataset. Ex, my data is structured like this: ServiceName EntityID A 00001 B 00001 C 00001 A 00002 B 00002 C 00002 A 00003 B 00003 A 00004 C 00005 etc... I need to be…
