Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 )
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?