Fiscal Year end month value need to assign to next fiscal year all months,

[#1]

Hi,

I am displaying fiscal year in means 12 months data in bar chart but, for one requirement I have to display last year end month value to this year all months.

If it is possible then please help me here.

[Anonymous]

Hi

Assuming fiscal year starts with JULY-16

=Date(Monthstart(YearStart(Max(Order_Date), -1,7),-1))      will give LAST fiscal month START  JUNE-15

=Date(MonthEnd(YearStart(Max(Order_Date), -1,7),-1))            will give LAST fiscal month END JUNE-15

=Sum({$ <MonthYear={"$(='>=' & Date(Monthstart(YearStart(Max(Order_Date), -1,7),-1)), 'MM/DD/YYYY') & '<=' &  Date(MonthEnd(YearStart(Max(Order_Date), -1,7),-1)), 'MM/DD/YYYY'))"}>} [Invoice Total])

the above expression gives the value of INVOICE TOTAL  in JUNE- 15 (say  50 )

[#3]

Hi Allu,

Thanks for your reply, but I can get the fiscal year value but how it will map to all next months upto nex year june?