Matt, go ahead and start a new thread, mention that you need the workbook made in 6.0, and it is okay to make up sample data, as long as it is representative of your situation, and I or someone else can provide help.

I managed to make it work with a countd if you would like to email me directly (so as not to add to this thead) feel free to do so. the way I did it may not be optimal (and I may change it once we upgrade to 6.1) but it works for now.

thanks for your posts. I learned a lot. I am trying to do the same thing, but I have an additional dimension on the rows shelf. For example, I need to display 20 clients and the top 10 exchanges of each client with the corresponding measure for that exchange. Anything that is not in the top 10 exchange should fall in the "OTHERS" category and being rolled up.

The image below show an example with two clients. The first dimension is called LEVEL 1 (it is actually a parameter that will correspond to different dimensions based on the user's selection). The second dimension is the SPLIT with OTHERS grouped.

I defined the calculated field Index (INDEX()) that ranks each SPLIT by addressing LEVEL 1 and SPLIT and sorts by T1 LOTS - GIVE IN:

"In top 10?" is a boolean calculated field defined as:

[Index] <= 10

and with the same Table Calculation configuration as Index.

The calculated field [SPLIT with OTHERS grouped (CLIENT OR EXCHANGE )] is defined as:

IF [In top 10?]

THEN ATTR([SPLIT])

ELSE "OTHERS"

END

I can't figure out how to roll up all the others to 1 row and to sum the measure of all the "OTHERS".

Is there a way to put an Index with and a color mark with a "Top N, with everyone else as 'Other'" view? I'm trying to get the columns similar to your workbook but have a barchart and rank in the view. (See attachment for example viz).

I have tried to add a percentage of total table calculation on sales. It returns the correct values for Top N, but does not aggregate the percentage for others. It actually shows the percentage of the 11th rank when Top N N=10.

any idea how can do a workaround calculation to display the correct percentage of others?

I applied what you did with Top_vendors_and_Other_example to my data and I was able to get upto the point where Tableau is separating out my top 10 agents from the "others". However, when I try to "condense Others", it is just picking out the one agent just below the top 10 instead of condensing all the others and showing me the total of Others. Can you please help?!

I have a similar issue. I want to show percent of total business as well for each of the top 10. then on the 11th or the Others line I want to show the percent of total minus the sum of the % from the Top N Customers. Having some issue with that calculation however. HELP!