Rank with dynamic sorting

[aj0031724]

Dear team,

Can you  please advise how to achieve RANK  output as below with dynamic sorting of KPI as shown

KPI	SORTORDER	formula
Drop Rates %	Desc	sum(count)/5
callcount	Asc	sum(count)

Master Table with KPI
id	name	Drop Rates %	callcount
1	A	5	5
2	B	5	5
3	C	10	10
4	D	10	10
5	E	2	2
6	F	3	3
7	G	7	7
8	H	1	1
9	I	4	4
10	J	4	4
11	k	4	4

OUTPUT REUIRED IN STARIGHT TABLE to DISPLAY 5 ROWS:

Id	name	Drop Rate%	Rank
3	C	10	1,2
4	D	10	1,2
7	G	7	3
1	A	5	4,5
2	B	5	4,5

ID	name	Calls Count	Rank
8	H	1	1
5	E	2	2
6	F	3	3
9	I	4	4,6
10	J	4	4,6

[aj0031724]

Dear Tresesco,

One diffrenece I noted. One thing that the requirement output was that for CALLCOUNT Rank output is hsowing 5 records but it ranked till4-6 because next ID also has same value.

As per the output requirement same values should be grouped but numbe rof records to display is controlled by vrank.

Can I get the output as shown above for CALLCOUNT.

	name	Calls Count	Rank
8	H	1	1
5	E	2	2
6	F	3	3
9	I	4	4,6
10	J	4	4,6