Compare Top 5 to Others

[Anonymous]

Hi Everyone,

I wanted to know how I can create a pie chart to compare my top 5 customers vs.  the rest.

eg.

Cus   Sales

A         10

B         5

C         6

D          8

E         1

F         1

G        2

H         3

I           2

J          2

So my pie chart would look like (excuse the ratio)

[Phil_Seamark · Accepted solution]

Hi @Anonymous

You could try a calculated column like this

Is Top 5 = 
VAR myRank = RANKX('Table1','Table1'[Sales])
RETURN IF(myRank<=5,"Top 5","Other")