Hmm. Couldn't find satisfactory simultaneous answers to both your questions.
1. Rank groups customers that have the exact same Load Count.
Rank_Unique will give sequential numbers even with ties, so you'll get your full 607.
2. But, Rank_Unique seems to get affected by the [Mode] on the color shelf.
I couldn't figure out a table setting that would ignore [Mode] and just
rank_unique the customers. Maybe someone can find it.
So I made a poor hack of changing the [Mode] to an attribute
and then using a reference line to show stacking of two modes.
Hopefully the Community will have other insights.
Please see workbook v18.1 attached in the Forum Thread.
284974rank.twbx 6.2 MB
Thank you so much for your help, Swaroop! However, I replaced the "Rank" function in my original calculation with "Rank_Unique", but I'm still getting only 443 as the total. I also tried recreating the "RankUnique - Loads" calculation you devised, but only get 443 with that too. Not sure what I'm doing wrong since I can see that all 607 showed up in your version. Any suggestions?
My apologies, I didn't specify the Table Calculation settings.
The settings will all depend upon what pills are on your worksheet.
In the "rank_unique" sheet, I only selected a compute using of "Customer".
But if you have [Mode] on the Color shelf, then you'll probably need
to set it like something below. Changing the order of the Dimensions
also changes the results.
Maybe you'll have a better go at it than I.
I tried many different orientations of dimension order and
many variations of check/uncheck, but couldn't get rank_unique to work
to ignore the Mode and not give back more rows than the selected 15.
That did it. Thank you!