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

[adh2]

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