Bucket Series for 100% Stacked Bar Chart




I have a 100% stacked bar chart for sales that has about 350 options in the series `Company Name`. The units are the number of sales so: count(`Sale Amount`)

I would like to bucket the companies that make up 1% or less of the total amount to simplify the legend. There is not a "limit rows" option for this type of chart.

How can this be done?



Thanks in advance for your help:)