Thanks for the reply. But this is not what I need. Please enable quick filter on state. If you start filtering on the state then the rank changes for statewide.
There are 50 states. I want to rank all the users in the country (country wide) and show that rank right next to the rank in the state. And I should still be able to filter the states in the view
the table calculation should ignore all the filters and calculate the rank of the user based on profit among all the users