For a client requirement, I need to display reports for Fiscal year instead of Calender year.
The fiscal year starts on April and ends on March.
Currently All standard datasources have Calender year as a characteristic.
Is it possible to create a Key Figure (calculated or restricted) such that we get Fiscal year instead of Calender year.
The reports to be displayed are like Collections YTD, Sales YTD etc.
For Ex: in case of Collections YTD
the x axis should contain April May June ... till current month)
and the Y axis should contain every months collections.
I have the collections data of every month,
The only thing I need to accomplish is x axis where the months should start from April and end in current month.
Thanks in advance,