PivotTable: filter to only include top five of values in a values column

Hi,


I know that I can filter a PivotTable to include only the top N records, but this is different. See the attached picture:
PivotTable.PNG
Imagine that this is a table showing fruit sales in different cities. For each fruit, I want to only include the top 5 cities, based on their value in sales.

So the distinct count-column will only show values up to 5, but not more. And the sum of sales-column will update accordingly.

Please let me know if there are any difficulties in understanding what I'm trying to say.

Thanks in advance.

Best,
Alfred

Thank you Oeldere,

Exactly like that! I've clearly underestimated PivotTables, they are so much more useful than I've thought.

Thank you!