Dynamic ranking

Hi all,

I am making a dashboard on Covid. i wish to include a table where country's rank per the #cases as of the date. e.g.

In my dashboard, i will have a timeline table with only country/#cases (rank will be hidden). Dates will change, so will the rank and hence the sequence of entries.

In the table in chart, i will only have one table and not 3 (this is just to show a running timeline over 3 days). Hope it makes sense and many thanks for your help!

Regards,

Amit Singla