Hi! I'm working on a personal project to breakdown some pok?mon vgc tournament data, and I want to discover the top 32 players decisions on their monsters moveset (set of 4 moves). So, the goal is when I select a species from the slicer, the Move Breakdown counts the distinct moves from list and counts them, to evaluate what moves players tend to choose on their monsters. I attached a file with data and an expected result (not in formula).

Is there any way to do it with "older formulas"? And with pivot table? Thank you!Top 32 VGC San Diego - Copy.xlsx