The below fiscal year conversion code : note here fiscal year started from July
if( num(Month(OrderDate))>6,Year(OrderDate)+1,Year(OrderDate)) as FiscalYear, // Converting Year in Fiscal year
'Q' & Ceil(If(num(Month(OrderDate))<=6,Right('00'&num(Month(OrderDate)+6),2),Right('00'&(num(Month(OrderDate))-6),2))/3) as FiscalQuarter, // Converting Quarter in Fiscal Quarter
If(num(Month(OrderDate))<=6,Right(num(Month(OrderDate)+6),2),Right((num(Month(OrderDate))-6),2))as FiscalMonth,// Converting Month in
Fiscal Month
=sum({$<FiscalYear = {$(=max(FiscalYear))}, FiscalMonth = {"<=$(=max({<FiscalYear={$(=max(FiscalYear))}>} FiscalMonth))>"}>} Sales*vCurrency)/1000
YTD:
