
1. Re: Top N with ties for a set
kumar bharat May 11, 2018 5:44 AM (in response to Jennifer Leo)Hi Leo,
Please check the following,it will help you out. (sets+top n)
hope it helps you.
BR,
bharat

2. Re: Top N with ties for a set
Jennifer Leo May 11, 2018 6:09 AM (in response to kumar bharat)Thank you very much for your reply. It is appreciated.
All of these are very interesting and helpful for creating sets with Top Ns and/or ranking. However (unless I am missing something), this doesn't seem to address my larger question. The end result I need is a Top 3 (that recognizes dense ties) the result of which can be used in a series of calculated fields for a different sheet entirely. Here are the methods I've tried (and the problems that resulted):
1.) I can create a Set using Top Ns (limited to 3) to use for a calculation. I can then use this calculation in my other layered calculations. What I can't do however is, is set it up so that it recognizes ties within that Top 3 (so that, say if the third and fourth one are tied, both are considered members of that Set).
2.) Alternatively, I can use a Rank table calculation so that I can retain ties (specifically dense ties), but because it is a table calculation I can't use the result of that rank table calculation in the calculations necessary for my other sheet (because that data doesn't exist in the that form for the table calculation to run properly in that second sheet).
So, is there a way to either a) get ties to be included within a Top N Set or b) a way to do ranking without using a table calculation (so that the result can be used in calculations for a different sheet with a different set up)? Or, is there another way entirely to achieve what I am looking for that I just haven't thought of?