Here you go.
Here is the calculated field used to display the year/month/date values as required.
Hope this helps. A 10.5 workbook is attached.
Year-Month-Date Sales.twbx 1.2 MB
Hari, This is exactly what I needed. Thanks!
I saw that many people needed this so hope it helps others.
Although this works great. Is there changes that need to be made if everything needs to be in fiscal year?
The YEAR(date) works with calendar year.
Nevermind, I worked out a solution.
Created a calculated field "Adjusted Fiscal Date" to adjust for the start of year to be October
Then replaced [Order Date] in your "Selected Date Range" formula with the new "Adjusted Fiscal Date"
Good, you figured it out.