Just wanted to chime in with my very ugly possible solution, as I have the same issue. I'm thinking about creating a webhook or workato automation that will generate a record on a child table for each user listed in the parent field, and then relating down all relevant fields. I will then create all reporting on the child table as now each record will have the unique value to tally up + the related fields will always be updated from the parent. (I have been thinking about this scenario for months, and this is the best I could come up with, hopefully it helps someone.)
