Hi ,
I am creating rank tie breaker but unfortunately not getting
1) Rank Profit
2) Rank Sales:
3) Rank Profit + Sales
current O/P:
Expected O/P
if we see Rank 10 is repeating for the 3 customers , in that case i want to take sales in to consideration and increase the rank accordingly
Rank Profit + SalesExpected O/PCustomer NameRank ProfitRank SalesSalesProfit33Tamara Chand1219052898155Raymond Buch231511769761011Adrian Barton5514,47454451012Sanjit Chand371414257571010Tom Ashbrook641459647041213Hunter Lopex48128735622
after increasing the Rank if any one the rank is equal to already presented rank then need to increase or left as it is.
File v: 2018.3
BR,
NB
Missed that part. I can't think of another solution.
I considered Prep, but that doesn't include RANK'ing (although you can create your own ranking functionality in Prep), but even then I am not sure if you can fulfill your requirement.
Another thought I had is to use TabPy. I have no experience for it myself, but it might be an option...
