Skip to Content
Former Member
Nov 12, 2014 at 11:43 AM

Need to display Fiscal year on x-axis of report


Hi All,

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,