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!