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

[paulyeo11]

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

[paulyeo11 · Accepted solution]

My QVW

[Anil_Babu_Samineni]

PFA

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

[paulyeo11]

‌Hi Anil

THank you very much  I am surprise that expression is able add the 2 field at the back of expression.  So that it will sum up the 2 amount .

THis is the first time I have experience this feature.

[Anil_Babu_Samineni]

If you want to supply 2 measures you can. But, make sure you may try with aggregate ir else it works only row level