Limit a pivot table with existing filters?

[The Student]

Hi, Hope someone can help.

I got a pivot table with filters.

In this case lets say I got product data on 20 products.
I choose to filter this table, so now I got 10 products selected

In addition I like to limit to top 5 (sales) out of the 10 selected products.

But it takes top limit out of the 20 products, not just the 10 products.

Is there a way to solve this?

I´m building a diagram where I like to show top 5 products in case the user choose more than 5 products from the slicers.

 

[BSALV]

IMHO, you have to add a aux. column with a formula in your sourcedata that gives the top-10 a "1" and the rest a "0", so that you can filter the top 10 for the 1st criterium and then in the pivottable filter on this column and work further with the 2nd criterium top-5.