Custom Ranking (preassigned Rank)

Hi Ashish_Mathur, Sorry was tied up into another task & could not reply to you.

This post got duplicated for unknown reason. Actually Zubair_Muhammad gave me a solution which worked well in summarised records. However, when I apply it to lengthy records where customer names appear multiple time in the same financial year, then for each line there are seperate Rank assigned (looks like).

Please see attached PBX file in OneDrive - https://1drv.ms/u/s!ArDh_5URL_X_bJxn8Pm3cMwnVfo 

with new table "Ranking_Sample" & page name = "Chandan".

I opted to take MIN of Rank, however, that defeats the purpose of keeping single Rank for each customer in a financial year and I get ranks like 17 & 37 whereas there are just Five customers in my table.

Need help.

Thanks,

Chandan