Report to display the GL balances according to Fiscal period

Hi Experts,

I have a requirment to display GL balances for the different account numbers from the table- faglflext

If the period is 3, the GL balances should add up the value from total= KSLVT to KSL03 and total1 =KSLVT to KSL02.

If the period is 10, the GL balances should add up the value from total= KSLVT to KSL03 and total1 = KSLVT to KSL02.

I have all the account balances for Debit & credit in one internal table,

Could you please let me know how I can apply the logic to show the total & Total 1 according to Fiscal period of the Run date.

Thanks

Vinay Pasalkar