Parameter for top N control in Tableau - Cell-by-Cell Formula Trace

Sample Data

Sales data for different products.

Cell	Value
A1	Product
B1	Sales
A2	Apples
B2	500
A3	Bananas
B3	300
A4	Cherries
B4	200
A5	Dates
B5	450
A6	Elderberries
B6	150

Formula Trace

RANK(SUM([Sales]), 'desc') <= [Top N Parameter]

Step 1: SUM([Sales]) for each product

Step 2: RANK(SUM([Sales]), 'desc')

Step 3: RANK(SUM([Sales]), 'desc') <= [Top N Parameter]

Cell Reference Map

    A          B
1 Product    Sales
2 Apples     500
3 Bananas    300
4 Cherries   200
5 Dates      450
6 Elderberries 150

[Top N Parameter] is a user input controlling how many top products to show.

The formula uses sales values from column B and a parameter controlling top N.

Result

    A          B       C
1 Product    Sales   Show?
2 Apples     500     TRUE
3 Dates      450     TRUE
4 Bananas    300     TRUE
5 Cherries   200     FALSE
6 Elderberries 150   FALSE

Only products ranked in the top N (3 here) show TRUE, controlling which products appear in the view.

Sheet Trace Quiz - 3 Questions

What does the RANK function do in this formula?

A Assigns a position number based on sales descending

B Calculates the sum of sales

C Filters products with sales above average

D Counts the number of products

Key Result

Use RANK(SUM([Measure]), 'desc') <= [Parameter] to filter top N items dynamically.