11 Replies Latest reply: May 26, 2016 5:15 AM by Stefan Wühl RSS

    How to get top 5 ranking diemensions in string format

    JISHNU MUKHERJEE
      ChannelSalesBrandDept
      Channel11235SamsungPhone
      Channel2354BlackberryPDA
      Channel3941OppoPhone
      Channel4341NokiaPhone
      Channel5924SansuiPhone
      Channel61733ToshibaTV
      Channel71460ApplePhone
      Channel81177MicromaxTV
      Channel91719Le10Phone
      Channel10917MaximaWatch
      Channel31585ApplePhone
      Channel41828MicromaxTablet
      Channel5689Le10Phone
      Channel61364SansuiPhone
      Channel71774ToshibaTV
      Channel8232ApplePhone
      Channel91093MicromaxPhone
      Channel101677Le10Phone
      Channel1375MaximaPhone
      Channel21579Le10Phone

       

      Hi I want to have the saleswise top 5 channels in text or string format not in number format .

      I have tried

      for first ranked channel - Aggr(if(Rank(Sum(Sales))=1,Channel),Channel)

      similarly for second , third , fourth and fifth i have used 2,3,4,5 but this is returning me in number format.


      Actually I need to feed this as an input to a set analysis where condition so it is important that this is in text or string format. Please provide any pointers.