23 Replies Latest reply: Aug 3, 2018 5:11 AM by Zaheer Latib RSS

    Ranking - need help

    Zaheer Latib

      Good Day

      Please assist or give me ideas on how to do this

      Have been using some statements, but just not coming right






      I need to first select the Top 40 customers ranked on their Sales, that shopped in a particular Group, let’s say I want to select for Juice


      Than from these top 40 customers ranked on their sales, I then need to show their sales for every Category, but only in 1 Division, lets call the Division Food


      So I am using this below, but am just not coming right, not sure if I am putting it in the dimension and not measure or the other way around






      Have tried the below expressions


      Please help and must the expressions be in the dimension or the measure


      sum({$<Customer= P({<Group={'Juice'}>}Customer), FiscalYear = {$(vMaxYear)}, FiscYMD = {"<=$(=(vMaxFYMD))"}>} Sales)




      sum({$<Customer= {"=rank(sum(Sales), 4)<= 40"}>} Sales) > 0,  Customer), Customer, null()))








      Thank you so much