top 10 in pie chart

[bouyazbekj]

Hello,

Have a table with customer name and total. 

I would like to have them in a pie chart with top 10, and one slice as other for the reamianing. 

Also I would like to have a matrix or table showing rank and % of total for all 

Thank you 

Customer	Total
Murphy Oil	2,212.00
XTO Energy	21,254.00
Cenovus FCCL Ltd.	887,546.00
Athabasca Oil Corporation	6,558.00
Rifle Shot Oil Corp.	5,423.00
MEG Energy Corp.	3,997.00
Crescent Point Energy Corp.	88123
Nexen	12,354.00
Shell Canada Ltd.	21,665.00
Keyera Energy	54,884.00
Arc Resources Ltd.	269,853.00
Paramount Resources Ltd	249,989.00
Husky Energy Inc.	21,868.00
Dienarian Resources Inc.	9,899.00
Serafina Energy Partnership	9,335.00
Tourmaline Oil Corp.	2,599.00
TransGas	5,668.00

[Zubair_Muhammad · Accepted solution]

@bouyazbekj

One way could be to add a calculated column in your Table

Top 10 Customers =
IF (
    [Total] IN TOPN ( 10, VALUES ( Table1[Total] ), [Total], DESC ),
    [Customer],
    "Others"
)

Now you can use this column in Pie Chart