8 Replies Latest reply: Feb 12, 2018 12:06 PM by Xavier Garcia RSS

    SET Analysis How to set date greater then 2016 ?

    Yeo Poh sai

      Hi

       

      Below expression work fine for year= 2016 :-

       

      Sum({<year={2016},REGION_={Singapore}, COMPANY = {"=Rank(Sum({<year = {2016}>} sales)) <= 8"}>} sales)

       

      I need to change the above expression for year 2016 2017 2018 . which is > 2016.

       

      I try below , but cannot work :-

       

      Sum({<year={">2016"},REGION_={Singapore}, COMPANY = {"=Rank(Sum({<year = {">2016"}>} sales)) <= 8"}>} sales)

      Sum({<year>={2016},REGION_={Singapore}, COMPANY = {"=Rank(Sum({<year >= {2016}>} sales)) <= 8"}>} sales)

       

      Hope some one can share with me.

       

      Paul Yeo