4 Replies Latest reply on Dec 27, 2017 1:28 PM by Hari Ankem

    How do I show my top 3 to look like one 'set of string'?

    Alysse Mea

      I have a dimension called Reason and wanted to show the top 3 Reasons. Top 3 will be the top 3 number of records with the given Reason. In the table below:

        

      ReasonNumber of Records
      Fall44,658
      Days44,045
      Months37,017
      Winter35,390
      Spring23,229
      Years20,052
      Summer9,228

       

      I want my view to be: Fall (44,658), Days (44,045), Months (37,017). I need it to be a calculated field, converting each to string and combining them all. Top 3 may or may not change.

       

      Please help! Thank you and Merry Christmas!