Any table calculation can't be applied across sheets.
A workaround is interactive the rank with a integer parameter, e.g. rank value < parameter value. But not sure whether this is what you are after?
If your bar chart and tabular report referring the same data source then you can work on apply to worksheets option. There you can select apply to related data source filter. This will enable you to achieve the result.