Dynamically Filtering of a pivot table

[mig17]

Hi everyone!

“New-Looker” here.

I have the following data: Month, Country, Amount of sales (generated per month)

I want a view that will have x = Date, Y = Amount of Sales, and I want to plot lines that represent the different countries.

As you can imagine, not all countries are important. Hence, I want to filter for the top 10 countries that sold the most and I want to do it dynamically.

I built the view using the Pivot option on date. but for the life of me, I cannot make a dynamic top selection!!!

I can filter out certain values, but I dont seem to pick the countries with the most sales.

My question is: How can I filter a view to return only the top 10 countries with most sales?

I hope I was clear!

Best regards