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 |
Hi Rao,
Check attached thread everything explained about TOP N & Others incl. advanced features;)
Hope it helps
Regards,
Norbert
Become a Viz Whiz on the Forums! Support the Community and master Tableau.