1 of 1 people found this helpful
Both INDEX() and RANK() are Table Calculations,
they're computed at the same (later) stage in the pipeline.
So a Table Calc Filter can not be applied before any other Table Calc.
Please refer to the Order of Operations page in Tableau Help:
In your particular case it is better to use
the Top N Filter on [SAP - Distributer] dimension
using the SUM( [Total Contract...] ) as the criterion.
Then you could omit INDEX() Filter and use RANK()
on the N (remaining) Marks on a view.
Top N Dimension Filter is calculated
just after the Context Filter(s) applied.
So any other regular Dimension filters
do not restrict the scope of Top N calc.
To make them restricting the scope,
they should be applied before the Top N Filter.
So the answer is -- put them in Context.