List of Unique values from a RollUp and Count of times used against each (Unique Value: Count)

Hi there. I am working with a Rollup up field linking between a Series table and ID table. The ID table has a field called Episodes. What I am trying to work out is how do I display the number of episodes linked from the linked ID table and the count of each.

Example:
Episode Roll Up
9, 5, 3, 3
(so there are four ID records linked to the Series table and from the ID table’s Episode field there is 1 x ID from Ep 9, 1 x ID from Ep 5 and 2 x IDs from Ep 3)

What I would like to display either directly in the RollUp field or in a companion Calculation field is the following:
3: 2
5: 1
9: 1
(so I’d like to be able to order the Episode numbers as well to make it cleaner to view).

I have searched thru the Community posts but can’t find anything that addresses this particular query. Any help would be very much appreciated!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.