Sum if constituent ID is in more than one list

There is a post here that might be helpful: https://community.tessituranetwork.com/tessitura_software_forums/f/tessitura_marketing-9/26336/crossover-sales-report/73384?_ga=2.102881541.461565057.1663600516-714990149.1662006053

I think the easiest option to try might be filtering a widget to one of the lists, then filtering the categories field section to the prod season IDs or performance IDs you want to count crossover for. 

Alternatively, you could create a third list where the criteria are "has [list 1]" AND "has [list 2]" to see crossover without a dashboard. The third list could be pulled into a dashboard afterward. 

There is a post here that might be helpful: https://community.tessituranetwork.com/tessitura_software_forums/f/tessitura_marketing-9/26336/crossover-sales-report/73384?_ga=2.102881541.461565057.1663600516-714990149.1662006053

I think the easiest option to try might be filtering a widget to one of the lists, then filtering the categories field section to the prod season IDs or performance IDs you want to count crossover for. 

Alternatively, you could create a third list where the criteria are "has [list 1]" AND "has [list 2]" to see crossover without a dashboard. The third list could be pulled into a dashboard afterward. 

Thanks this is useful info!