Using INDEX to filter top N values within a category [Video]

Posted by on Oct 1, 2012

This video is the third in a series of videos which aim to explain the use of the index() function in Tableau – specifically for using it to provide a rank of data points.

If you are new to the subject, and have not yet watched the previous videos, I suggest you watch these first:


Getting started with index for ranking values

Using index to rank values within a category

the following posts are also relevant

Making Table Calculations work

Blue and green things


In this video, we demonstrate how to make use of the INDEX function to create a rank which provide a TOP N filter within a category


Tom Brown

Tom Brown

Founder & Managing Director
Tom Brown

Latest posts by Tom Brown (see all)


  1. Fantastic web site. Lots of helpful information here. I’m sending it to some friends ans additionally sharing in delicious. And naturally, thank you for your effort!

    • Thanks for your kind words Kayleen.

      • Hi Top, in your video here, could you teach us how to do this across multiple months? say top N sales in these region for the last 3 months? Thanks.

  2. Perfect – thank you. Just what I needed!

  3. Hi, i have used INDEX() to rank a table of string information.
    What i would like to do is show only the last 3 inputs to each client.
    some clients have 6 inputs some 30, so my end result would be Client 1 shows RANK 4, 5 & 6 while Client 2 shows RANK 28, 29 & 30

    I cant seem to get a TOP filter and also this is 2 tables in an Access database connected by a Primary Key and Secondary Key.

    Please help?

Leave a Reply

Your email address will not be published. Required fields are marked *