Using Top N Filter and sum the rest as “Other”

Question & Answer
,
1

I would like to present Top N, and the rest that’s not include in the N will be sum together and present as “other”. How can I do that?

2

Hi @May2
i guess you have to create caluclated field where you assign the 1…n and “others”. something like
ifelse(rank<10,toString(rank),"others")
BR

3

Hi @May2

Please check the similar usecase and its solution in the below democentral Tips&Tricks section

https://democentral.learnquicksight.online/#Dashboard-TipsAndTricks-Calculation-Dynamic-Others-Group