Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Using Rank function in New Expression labelled as Rank and giving definition as =Aggr(Rank(Sum(Value),1,1),Numbers) and getting this result.
But the requirement is this one:
Please let me know if i am doing any mistake in defining expression.
if the resulting number is the same, rank will always give you the same rank. what you can do is add a bias in the rank. if your rule is for the same rank sort by alphabetical order and the first has a higher/lower rank - assign a very small fraction to your individual IDs making sure the largest will never influence your result.
for example, you have 1000 IDs and your Value is always integer. assign your bias as 1/10000 for the first and 1000/10000 for the last (you can do this programmatically using rownum
this way you rank using expression + bias so the 54 value would result in 54.0001 and 54.0002 so QV will be able to rank it per customer