Bucket Series for 100% Stacked Bar Chart

AJ2020

Hi,

 

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:)

jaeW_at_Onyx

https://www.youtube.com/watch?v=39VHAQEYHAc&t=220s

Covered that requirement in this use video