1 Reply Latest reply on Nov 16, 2018 8:11 AM by Norbert Maijoor

Summing up others and show in single row along with top 5

rao marapatla Nov 16, 2018 7:51 AM

Hi All,

I have a scenario which I wanted to show top and rest all are in one row as Others - i can able to get top and remains are as others now wanted to sum up all others and show in single row followed by top 5.

please find attached workbook

below is expected output

_DisplayCities	Sales	% Sales
Bologna	16,941	32.35855904
Florence	13,459	25.70768232
Milan	9,825	18.76647439
Verona	7,100	13.56152347
Naples	3,694	7.055812354
others	1,335	2.549948428

Workbook_v10.5- top 5 and others not summing up and show in one row.twbx 20.4 KB

1. Re: Summing up others and show in single row along with top 5

Norbert Maijoor Nov 16, 2018 8:11 AM (in response to rao marapatla)

Hi Rao,

Check attached thread everything explained about TOP N & Others incl. advanced features;)

Hope it helps

Regards,
Norbert
Like Show 0 Likes(0)

Actions

Tableau Community Forums

Summing up others and show in single row along with top 5

1. Re: Summing up others and show in single row along with top 5

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account