In my project the fiscal year start from October, so in the chart I have to show if the month is October then is should show previous fiscalyear data(oct 2017 to nov 2018).
something like--if (FISCAL YEAR+1)= Previous Year Data.
A frontend solution could be very expensive because you would need to add these (not simple) matchings and calculations to each expression/object which should cover this functionality and it could decrease the performance quite heavily - therefore the clear suggestion: do it within the datamodel and not within the UI.
