Best Way - Create pie chart on top fruits plus last is "other"

Hello,

What is the best way to create a pie chart based on data to calculate the top 9 categories (multiple rows with $ as top and fruit as category) and then have the 10th value as "other" (needs to sum the remaining categories that are not in top 9). I also want to omit the category "TBD" as a top 9. What is the best way to do this? I know a pivot table is a perfect way to do this, but I need the other categories to be grouped as "other" and I need TBD removed from list. If I go to top 10 - that doesn't work... what kind of formulas would you use to make this work?

Let's say the Category is Column A and the price is Column B.

Thanks so much!

There are multiple categories that need to be summed so the top 9 need to be found based on the total sum of each category, not item. TBD also needs to be removed and the formulas need to be as automatic as possible.

Sum categories extract to overview tab.xlsx

Will do! Attached is the spreadsheet. I have a pivot table but need this to work where I only see top 9 then the other two categories need to get summed together and then changed to "other". The overview tab has what I'm looking for