9 Replies Latest reply on Aug 7, 2018 12:21 AM by Ankit Bansal

    Sum of [measure] on the basis of {Top N rank} with (date as filter)

    Devesh Soni

      Hello there,


      I am creating a calculation in which I would like to calculate SUM([Quantity]) on the basis on Top N rank of Product Name.

      I have tried a calculation on Rank and using that in filter but that hardly worked.


      Calculation used in filter -

           IF RANK(SUM([Quantity]))<11 THEN






      I want to show only 1,005 on sheet. (Product name wise SUM of Quantity on Rank<=10)

      Although I got this:



      Data Source - Sample Super Store

      Version - Tableau Desktop 10.5


      Any help would be appreciated.


      Thank You.