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



  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!

  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 *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>