I have worked quiet a bit with the ranking feature in Tableau. Unfortunately, I'm using an older version, so I'm not able to open your example. Would you be able to add a screenshot of your attempt at ranking?
(Note to self: V9.3 workbook.)
I have this open.
I'm not clear on what you are looking to get. Are you saying you want to be able to do top-N on the "Desired ..." sheet? So just show from phones down to Appliances (if N = 10)? Still broken into segment colors?
Thank you Joe - you're interpretation of what I was trying to do was accurate.
I tried to recreate the view myself and where I struggled was getting the Table Calc in the rows shelf to have the correct partitioning and addressing. (see the screenshot below) I finally got it to work - not sure if I can retrace my steps next time I need to do this, but at least I have a working example.