FSG having YTD for Balance Sheet accounts and PTD for I/S accounts

Hi,

The requirement of our business partner is to have a 12-month trending report showing YTD balances for Balance Sheet accounts and monthly activity ( PTD ) for Income Statement accounts.

I am defining a FSG report with 12 column sets with amount type PTD-Actual. To get the YTD Balances for Balance Sheet Accounts, I have set Amount Type 'YTD-Actual' on row set row with balance sheet accounts.

I am getting I/S accounts accurately with monthly activity as desired.

For Balance Sheet Accounts, the first period (&POI0) is showing accurately. However for the subsequent periods, first period amounts are getting displayed. I would expect the YTD-Actuals of each month displayed.