1 Reply Latest reply on Jul 31, 2013 5:53 AM by Jim Wahl

    How do I group smaller sections of a pie chart?

    Andreas Linden

      Hi,

       

      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!

       

      Andy