1 Reply Latest reply: Jun 29, 2016 12:23 PM by Sunny Talwar RSS

    Sum of Top 10 Rank

    Darmawan Suria

      Hi,

       

      I want to sum the Top 10 Rank with Category = "DPK", Anybody can tell me what is wrong with my Measure :

      Sum({<CUST_NAME = {"=Rank(Sum({$<MONTHYEAR = {"$(=max(MONTHYEAR))"}, CATEGORY = {DPK}>} BALANCE_IDR)) <=10"}>} BALANCE_IDR)

       

      I can get the total of Sales with this measure :

      sum({$<MONTHYEAR = {"$(=max(MONTHYEAR))"}, CATEGORY = {DPK}>} BALANCE_IDR)

       

      Top 10.jpg)

       

      Thanks