If you want the data to be live (as opposed to updated periodically by a crown job), I don’t think this would be possible (at least not in an easy way) to do from the list view. It should be relatively straightforward to do with a custom report. That would probably be the way I’d approach it.