2 Replies Latest reply on Jul 3, 2018 6:12 AM by Rohit H B

    Top 100 in Prep?

    Rohit H B

      Hi

       

      Is it possible identify and filter top 100 values of a dimension based on a measure value in Prep. Have data in the below form in DB and have a requirement to include only the top 100 Category 2 for every Category 1 ( based on revenue) into the visualization ( extract based) , wanted to know if its possible to do this using Prep ( identify top 100 and filter out the rest) by using rank or any other function?

       

       

        

      Category 1Category 2Revenue
      A1A123
      2A56789
      ..
      ..
      ..
      10000A5643
      B1A123
      2A56789
      ..
      ..
      ..
      10000A5643