9 Replies Latest reply on Sep 21, 2016 12:40 PM by Luciano Vasconcelos

    Getting LAST after filtering

    Cameron Baird

         For each customer I'm trying to filter to only see the row of their 10th order or if they don't have 10 orders than I'd want to see the row of their max order #.

       

      I tried Indexing the Order #'s and filtering to show only the the top 10 and then creating a table calc to show the last row but for customer "B" I am unable to get the LAST field to show TRUE on row 10, it still wants to show Row 12 as LAST. Any help would be greatly appreciated.

       

      Raw Data

       

      Desired Results: