4 Replies Latest reply: May 5, 2017 8:02 AM by Maheswara Reddy RSS

    How to combine 2 chart into 1 chart ?

    Yeo Poh sai

      Hi All

       

      I have 2 chart A & B. I like to combine into one chart C.

       

      My Chart A expression as below :-

       

      Sum({<SEGMENT -= {'Related Coy'} >}total_ar * Pick(Match(US_Cust_AR, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD', 'MYR', 'RP'), 1.64, (1/24), 1.25, 0.012, 1/24, 1,1/3,1/9600))

       

       

       

      My Chart B expression as below :-

       

       

      Sum(total_ar * Pick(Match(US_Cust_AR, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD', 'MYR', 'RP'), 1.64, (1/24), 1.25, 0.012, 1/24, 1,1/3,1/9600))

       

       

      Both Chart A & B have same dimension :-

       

      =If(aging_ar >= 1 and aging_ar <= 30, Dual('1-30', 1),

       

      If(aging_ar >= 31 and aging_ar <= 60, Dual('31-60', 2),

      If(aging_ar >= 61 and aging_ar <= 90, Dual('61-90', 3),

      If(aging_ar >= 91 and aging_ar <= 120, Dual('91-120', 4),

      If(aging_ar >= 121 and aging_ar <= 150, Dual('121-150', 5),

      If(aging_ar >= 151 and aging_ar <= 180, Dual('151-180', 6), Dual('>181', 7)))))))

       

       

      Hope some one can advise me.

       

       

      Paul Yeo