You are using Fiscal year starting from July, and "IncidentCount2016" does not show correct fiscal year as calculated results.
(that calculates "calendar year")
I added "Fiscal year" field to calculate incidentcount2016(copy).
[Fiscal Year (insert date)]
if month([Insert Date])>6 then year([Insert Date])+1 else year([Insert Date]) end
COUNTD(IIF([Fiscal Year (insert date)] = 2016,[Incident Number],NULL))
Then sort [Incident Product Code] by the field of [IncidentCount2016 (copy)]
ForumSort_9.1.twbx 171.4 KB
Working as expected. Cheers mate
You are very welcome