Thanks for your response. What I want is something like the image but just with the top ten director names filter by budget (the first ten names of the list) keeping their current ranking in profits.
More precisely, what I want is the graph in Sheet1(2) with the right values of the ranks.
I just removed the table calculation from the columns and left the SUM(Budget). Thanks!