I have developed reports that display pie charts based on queries. Some of
my reports may contain 10-20 categories though only a few categories contain
the majority of the data. The problem with pie charts is that the legends
(when utilitizing this many categories) are displayed on top of each other.


Does anyone know an expression or other way of grouping data from categories
whose data is less than 5% (as an example) into an "other" category so to
minimize the number of categories displayed in the pie cart and thereby improving
the format and display of the data and legends?

Thanks.