I have a similar challenge from a customer query so speaking in hypotheticals.
Use case: I have ONE email and sending to multiple lists as once-offs OR one email using smart content using multiple lists. How can I create a report that shows email performance analytics per list? Ideally a chart with lists as rows and each email performance metric has a column. I’ve tried using a pivot table in the customer builder with Contacts, Marketing Email and Marketing Email Activities as sources. Also tried Contacts + Marketing Email Analytics (in Beta). As Lists are only available in the builder as filters, I think this is simply not possible without exporting and pivoting in Excel.