I'm trying to generate a pie chart of revenues by product. We have hundreds of products - I'd like to group the ones with lower revenues as one 'piece' of the pie, to avoid hundreds of slices! Is it possible to automate this? I've tried the group function but it doesn't allow grouping by revenue size. Using a 'set' might work, but I've only managed to exclude products with smaller revenues, not include them in an 'other' slice.
Any help would be much appreciated!