Pie Chart Grouped By Ranking

Hi Andvil ,

Actually, what that user created is calculated table not measure or calculated column. If you used his provided formula with calculated table, it works well. Please check the below screen shot. 

In addition, there is another method: create 5 different measure to display the summarized sales of these 5 five partitions.

You can refer the details of both methods in this link.

Best Regards

Rena

Hi Andvil ,

As checked the formula which you created in your report file, it is CORRECT.  And why those specific 3 companies didn't display in Pie Chart besides others and top 5 companies, it is due to companies "ENTREGAS ESPECIALES ESPENTREGAS S.A.", "DHL EXPRESS ECUADOR S.A." and "LAARCOURIER EXPRESS S.A." with very small proportion as compared with others and top 5 companies group. So they cannot be displayed on Pie Chart. Maybe you can use other visual(for example: clustered column chart etc. ) to represent the proportion just like below screen shot.

Best Regards

Rena