This is how I currently have it setup. But the problem is I can't switch between them in a view. I would have to have both date fields added. I'm trying to just have one date field and use a parameter to set the the start of the fiscal year.
As you mentioned you need a FY start date.
Create two parameters - [start date fy ] and [end date fy ]
Create two calculated fields
FY July ? :
[FY July Date] > [start date fy ] and [FY July Date] < [end date fy ]
Drag the above cal and set it to true in July FY sheet
FY Sept ?:
[FY Sept Date]>[start date fy ] and [FY Sept Date] < [end date fy ]
Drag the above cal and set it to true in Sept view sheet
Add FY July date to detail in July sheet and FY Sept date to detail in Sept sheet, so that FY years start can be identified
Find the workbook
Diff FY's.twbx 1.2 MB
Where you able to achieve results for selecting /setting Fiscal year start month using parameter.I have to finish a report which requires the view to do the above .