6 Replies Latest reply: Jul 26, 2016 8:22 AM by arul settu RSS

    How to make SOURCE={'TDSS'} Dynamic ?

    PAUL YEO

      Hi All


      Now i need 3 Table , my goal is make it only 1 table .

       

      Expression for TDSS :-

      Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"},SOURCE={'TDSS'}>}BK_TAR)

       

       

      Expression for TDST

      Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"},SOURCE={'TDST'}>}BK_TAR)

       

       

      Expression for TDSID :-

      Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"},SOURCE={'TDSID'}>}BK_TAR)

       

       

      May i know how to make it dynamic :-

       

       

      when i select SOURCE = TDSS , Table 1 will display Monthly target = 76,389.00

      when i select SOURCE = TDST , Table 1 will display Monthly target = 34,722.00

      when i select SOURCE = TDSID , Table 1 will display Monthly target = 27,777.78

       

       

      Paul