2 Replies Latest reply on Jul 23, 2018 9:54 AM by Hima vardhan Reddy Pavuluri

    Top 3 and Others with in sub-category ?

    Hima vardhan Reddy Pavuluri

      I am using sample superstore data to illustrate the challenge I am facing :

      I need to divide sub-categories into top 3 with names and all others into Others based on sales with in each category with out using grouping (as it is static). Any ideas ?

       

      Input :

       

      Expected Output :