I created a The pie Chart which has so many legends, is there a way to combine all the top-5 into ot

One way to do this is to create the set!

Let’s say we need a pie chart on subcategory and want the top 5 subcategories to be shown in one.

To do that, first, find the top 5 subcategories based on the sales-

Then we need to create a set for these top subcategories-

This way you will be able to achieve. A separate set will be created for the top 5 subcategories. And then you can create a report like this which is not the pie but can work for your requirements.