How to combine 2 table into 1 ?

[paulyeo11]

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

[paulyeo11]

Hi Krish

Many thank for your sharing.

I have try but it does not work.

Hope you can point to me where i go wrong ?

Paul Yeo

[paulyeo11]

Hi Krish

Hi Sir

I manage to figure out , and now it is working fine in table 1.

I now need to modify the expression to compute >90 day and less then 120 day.

I expect the result of the table should display 5304 and 687.

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

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

I have try the above expression , but it does not return any value.

Paul

[paulyeo11]

Hi Krish

I post one more similar issue , can you help to take a look ?

Create var vYn1 and replace 8 with $(vYn1) not working ?

Paul