Join Table problem

[GraceGao]

Hi Experts,

i have 2 tables as below screenshot.  for the actual data table, there is updated period and period , for the budget data just have period, i would like to analysis actual vs qty by month.

months comes from period with selected updated period. then i put one navigational panel to select updated period. however, this selection cause budget data filtered out. How could i implement this ? Please advise. Thanks.

[Prashant_Naik]

Hello,

As per my understanding, you want to show period wise Actual and Budget Qty.

For that you can just load the tables and associate both the table on Period, Like done in attached QVF.

Regards,

Prashant

[GraceGao]

Thanks for your help.

i have check your qvf file, in this case the jan actual qty is 200. i would like to select updated period for example choose 2019-05, then display actual qty and budget qty.

expected result:  choose 2019-05

 period         actual        budget

Jan-2019     100            500

Feb-2019     101            501

Mar-2019    102             502

......

Dec-2019   0                  511