I'm stuck - how to create a pie chart (or any chart at this point) which shows top 10 values and sums all other values into "Others) BUT the source is a dynamic array (or Pivot Table).

I've been wracking my brain trying to come up with different solutions ranging from Pivot Chart to GROUPBY function from Excel but all come up short. Basically, my source data is going to be presented as a "per week" basis e.g.

Filter: Week 1

Different weeks might show different houses and different hours.

What I want the chart to show is just the top 10 houses with the most hours then all other houses would be lumped into "others" where all the hours are added up, that way I would minimize the amount of entries into the chart.