Company RANK Financial_Year
A 21 2021
A 22 2022
B 46 2021
B 56 2021
C 78 2021
C 36 2022
I just want to show current year rank - Previous year rank in a dynamic way. That means if new data is loaded its automatically calculates the rank and displays. Please someone help me over this its really urgent.