Good day Sunil.
I'd suggest two calculations. The first to compute the fiscal year as a number. The second takes the number, and generates the range.
[FY (Number)] (assumes fiscal year begins in July):
YEAR([Order Date]) + IF MONTH([Order Date]) >= 7 THEN 1 ELSE 0 END
Change the 7 (July) to whatever month your fiscal year begins in. Next generate the header:
'FY ' + STR([FY (Number)]) + '-' + STR([FY (Number)]+1)
or using Superstore data:
Does this help?
Book1.twbx 2.4 MB