Is it possible to create a pie chart that shows the top five customers but then calculates the next five largest customers (customers 6-10) as one group and then the remaining customers as one group (creating seven pie slices)?
Yes! This is possible. You would either need to create a text multiple choice field on the customer table that assigns the segment, or you can create a segments table that is a parent of customers to automate the assignment of segments based on some criteria that ranks customers by size. Then build your pie based off this segment chart.
Please contact me if you need assistance - my contact info is in my profile.