3 Replies Latest reply: Mar 23, 2016 6:38 PM by PAUL YEO RSS

    How to make my target chart ok when not select current month and yr ?

    PAUL YEO

      Hi All

       

       

      chart 1 expression work fine when select current month and year :-

       

       

      sum({$<year = {$(=max(year)-0)}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}sales_target/$(Columndim89)/1000)

      , $(vMoneyFormatK))

       

       

      Table 1 expression work fine when not select month and year :-

       

       

      Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales_target/$(Columndim89)/1000)

      , $(vMoneyFormatK))

       

       

      In order to make chart 2 don't need to select current month and year , i use Table 1 expression for chart 2 expression :-

       

       

      Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales_target/$(Columndim89)/1000)

      , $(vMoneyFormatK))

       

       

      I expect Chart 2 to display the bar value same as Table 1. But it does not work. Hope some one can help me.

       

       

       

       

      Paul