HOW TO GET FISCALYEAR PERIOD WISE DATA BY GIVING FISCAL YEAR AS INPUT
I have to display data for customer balances on fiscper by giving the Fiscal year as the input parameter.
Fiscal Year variant is J3 i.e; April to March.
For ex1: if i give the Fiscal year as 2015(now as we are August,report should display data from April to July).
Fiscal year/period Customer Balance
Ex2: Suppose we are in April 2015, If i execute the report in April month it should display the data for the previous finacial year that is from April 2014 to March2015.
I want to show above two scenario's in single report.
All your suggestions and assistance are highly appreciable.
As suggested by Loed, you can create Customer exit variable to get the periods from start of fiscal month to current month as well as to get the previous fiscal year value.
More over I see that you have requested for the ourput that too period wise.
For that i suggest you to create another structure in Row for diffrent periods. In this structure you can categorize your data or say Key figure value (customer balance) . this is going to be your cell Structure. so it will geive you fix ouput report, Its just that your values gets changed according to the input you are giving.
Hope this helps.
Thanks & Regards,