Hi,
I'm trying to build a dashboard to show crossover of audiences for different strands of our classical season. I have saved a list for each strand.
I need a formula to count a constituent Id if it is included in more than one list, so some variation of sum if [constituent id] [list A] and [list B]
Any ideas?
Thanks
Hi Ogo,
When you put in the List Filter it should give you the option of adding multiple lists, and in the upper right corner you can choose if you want to filter based on folks in one list OR the other, or based on folks in one list AND the other:
How did I forget about this?! Thank you