Use your year as filter instead of drag it to page, page is something like a view filter, the data behind is actually not fitlered, so the rank isn't based on what data filter from the view, but calculated regardless of the view filter.
Below is the sample using filter rather than page to filter the data and the rank looks correct.
Workbook attached for your reference.
GDP RANKING_v10.5.twbx 145.0 KB
1 of 1 people found this helpful
I looked at the video - don't think this was done with Pages shelf
Pages work ad different points in the order of operation - I think this was probably individual sheets filtered by year and strung together in a recording
you would not need rank jus sort by the GDP -
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thanks that is work with me but in a manual way, i think i will search more to be automate.
Hey Ahmed did you got any solution over this?