6 Replies Latest reply: Feb 21, 2018 3:06 AM by Yeo Poh sai RSS

    SET expression add new condition sub_seg={"02"} not working

    Yeo Poh sai


      Hi All


      Below expression work fine :-


      Sum({<year={2016}, COMPANY = {"=Rank(Sum({<year = {2016}>} sales)) <= 5"}>} sales)


      I try to add new condition sub_seg={"02"} to above expression , it does not work  :-


      Sum({$< SOURCE  ={"TDSS"},sub_seg={"02"},COMPANY = {"=Rank(Sum({<year = {2018}>} sales)) <= 5"}>} sales/1000)


      Hopw some one can share wifh me why ?


      Paul