3 Replies Latest reply: Apr 4, 2016 7:18 PM by PAUL YEO RSS

    SET expression how to add filter year > 2009 ?

    PAUL YEO

      Hi All

       

       

      sum({$<year = {">=$(=max(year),4)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}, COMPETITOR = {'WAGO', 'iTDS'}>}distinct REVENUE_C)/1000000

       

       

      Above expression from sunny , will plot the year from 2000 till YTD , may i know how to add filter to above expression , so that it will plot from year more then 2009 ?

       

       

      Meaning i only want to see the chart 1 , X axis display from 2009 till 2015.

       

       

      Paul