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

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

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

My QVW

• ###### Re: I have 2 table . How to make the 2 table become 1 table

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))

• ###### Re: I have 2 table . How to make the 2 table become 1 table

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.

• ###### Re: I have 2 table . How to make the 2 table become 1 table

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