4 Replies Latest reply: Feb 13, 2018 7:50 PM by Anil Babu 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