FSG Reports with Monthly balances of P&L accounts
Hi Gurus,
I have a requirement to create FSG report if run for any period then P&L accounts data should appear as monthly columns and the last column should be Total.
Example. Financial Year is Jan-Dec
so if i run it for Jun-22 then report should display Jan-22 | Feb-22 | Mar-22 | Apr-22 | My-22 | June-22| Total YTD|
How to achieve this requirement. The monthly column should appear dynamically as per the period given while running the report. Lets say it the report is run for Feb-22 then only 2 months should appear Jan-22 & Feb-22
I have already created one report with 12 monthly columns but that is one the basis of using offset value from POI.