In looking for help with a report that I am trying to configure, I came across this thread. The above information is great and gets me halfway there for what I am looking to do but am stumped on one aspect on my report. Would you have any insight as to how to have a report show year over year by fiscal year , instead of by calendar year? I am looking to do some fiscal year over year reporting with regard to projects. Right now on the report I have been trying to build (using information provided above), it is showing Year groupings on the chart of Year 2016, Year 2017 and Year 2018. For my purposes, although a project may have been completed in calendar year 2016, it may be considered a fiscal year 2017 project, so I want it to show/be counted under fiscal year 2017 on the chart, so fiscal year to fiscal year can be compared. Hopefully this makes sense. I have a sneaky suspicion that this may involve some calculated expression that I would have to apply somewhere and any help with that would be greatly appreciated as well.
Currently, I run the reports in Workfront to get the information for each fiscal year, export the information out to Excel, format/configure the information to get the year over year, then create chart(s) - all of which takes a pretty fair amount of time to do. If I can get this to work in Workfront, I would get some days back!
Thanks so much in advance for any help. Terry Hynd EBSCO Information Services