Top 15 records and to show others as one group in table chart

[Anonymous]

Hi,

I have requirement to show top 15 records and rest all other records to Show as Others,
I have one Employee ID's column and one  calculated colum- Total Efforts spent 

I have to show top 15 Employees with total efforts spent and rest all Other employees to show as "Others" in Table Chart.

Any help?

Thanks
Likhitha



Thanks

[Anonymous · Accepted solution]

Hi @Anonymous 

You can refer to the following example

create a new column in the table

Type = var _top15=SUMMARIZE(TOPN(15,'Table',[Total],DESC),[ID])
return IF([ID] in _top15,FORMAT([ID],""),"Ohter")

Then put the column to the table  visual, and create a new measure in the table

Measure 2 = SUM('Table'[Total])

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AlB]

Hi @Anonymous 

Can you provides some sample data?

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.