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

           RANK(SUM([Quantity]),'desc')

           END

       

      image.png

       

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

      Although I got this:

      image.png

       

      Data Source - Sample Super Store

      Version - Tableau Desktop 10.5

       

      Any help would be appreciated.

       

      Thank You.