12 Replies Latest reply: Dec 21, 2017 9:43 PM by Yeo Poh sai RSS

    How to combine 2 table into 1 ?

    Yeo Poh sai

      Hi All


      I have 2 Table :-


      Table 1 Expression :-

      If(Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=91'} >}total_ar  * 1) > 0,

      Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=91'} >}total_ar  * 1))


      Table 2 Expression :-

      If(Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=91'} >}total_ar  * 1) > 0,

      Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=91'} >}total_ar  * 1))



      May i know how to combine both table into 1 Table. and user just need to click on the button >90 Day or > 120 day ?


      Now i manage this issue by 2 sheet.


      Paul Yeo