10 Replies Latest reply: Apr 4, 2016 7:18 AM by PAUL YEO RSS

    How to make my chart 1 also work fine , if i not select year = 2015 ?

    PAUL YEO

      Hi All

       

       

       

       

      My expression BELOW work fine FOR CHART 1 when i select year = 2015 :-

       

       

      Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}distinct REVENUE_C/1000)

       

       

      My question is how to make my chart 1 also work fine , if i not select year = 2015 ?

       

       

      Paul