Filters and Counting

Hi there,

I did a bit of playing around and came up with the attached, working of a couple of pivot tables, countifs, ranking and lookup formula.

I added an additional column to your table (hidden in column B. This basically gives each record a unique number to ensure identical records are not 'bundled' in the pivot table.

On the dashboard tab, use the slicer to select your Species. This only works for selecting 1 species. If you select multiple, the data for the first Species will be shown.
The Moves Usage Breakdown will show you the top 10 moves.

Someone may can provide a more elegant options, but the attached may gives you a start.