4 Replies Latest reply: Feb 13, 2018 7:50 PM by Anil Samineni RSS

    I have 2 table . How to make the 2 table become 1 table

    Yeo Poh sai

      Hi All


      I have 2 table . I want to make the 2 table become 1 table.


      SUM({<year = {'$(=Max(year))'}, month = {"<=$(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today()))))"}>}sales/1000)


      Both of the table having same expression. But dimension for


      Table 1 GROUP_CLASS

      Table 2 GROUP_TYPE


      can some one advise me how to use use SET analysis :-


      So that i can compute the Different of Table 1 and 2 for each row.



      Paul Yeo