Union Statistics Dashboard for Unique Member Counts and Affiliation Totals

I want a "Union Statistics Dashboard" that provides a consolidated view of unique member counts across all clubs for a specific year (e.g., 2025). Currently, I have to export and deduplicate lists manually. It should also show the total number of affiliated clubs for that period automatically.