Forum Discussion

pshah's avatar
pshah
Regular Visitor
8 years ago
Solved

TopN + Others

I need to show Top(N) with Others... so say I want to see a total of 5 rows, but I want to show Top(3) and have the other 2 as "Others"... how would I go about doing that?   So my Top(3) are Japan,...
  • parry2k's avatar
    parry2k
    8 years ago

    Try this with measure:

     

    TopN + Others = IF ([Ctry Rank] <= 3, MAX(Country[Country Name]), "Others")
parry2k's avatar
parry2k
Super User
8 years ago

Try this with measure:

 

TopN + Others = IF ([Ctry Rank] <= 3, MAX(Country[Country Name]), "Others")
andrashodi's avatar
andrashodi
Regular Visitor
7 years ago

Hi, 

 

How would it be possibile to visualize this categorizations on a column/pie chart? I replicated the solution and looks fine in a table, but I am not able to create a visual on it. For example, there are many bank accounts and I want to show top N as individual columns (say where the balance exceeds 1million) and the rest as "others" as one bar with their balances summarized.

Could you please help?