Rank function on the PIVOT column in Qlik sense

[#1]

Hi Experts,

   I am not able to rank based on the column in the pivot table. I have a pivot table as follows

Candidate Names	English	Hindi	Maths	Science	Social
Candidate 1	50	20	10	10	20
Candidate 2	90	100	80	60	30
Candiate 3	45	67	98	79	50
Candidate 4	50	50	30	30	20

Now, I have to give rank based on the subject marks secured by the candidate. The output should be as follows

Candidate Names	English	Hindi	Maths	Science	Social
Candidate 1	1	2	3	3	2
Candidate 2	2	1	3	4	5
Candiate 3	5	3	1	2	4
Candidate 4	1	1	2	2	3

How can I achieve this in Qlik Sense expressions? I could not done this by using RANK function?

Please help me out. I appreciate the quick solution .  Thanks in advance

[#2]

Qlik Sense Pivot Table Rank by one measure by display another

This might help

[#3]

Thanks you very much for your quick response Sai. I have derived the required function from the link which you shared.

The expression is like this

AGGR(Rank(sum(marks),1),  [SubjectNames])

Thanks once again sai.

[#4]

Thanks much for your feedback Narendra Kumar!!

Could you please mark the answer and also close the thread.

Regards

Sai.