<< Back

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

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

London, UK

5 thoughts on “Using INDEX to filter top N values within a category [Video]

  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!

      1. 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. 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 *