Hello,
I am trying to align some data in a report to fiscal years. There are many different dates in the table - things for staff members like start dates, end dates, promotion dates, contract end dates, created dates, etc. etc. I've created a Calendar Table that correctly identifies fiscal years, but the problem I'm running into is how do I leverage that calendar table to apply the fiscal year to all of the different dates? I can form a relationship with one set of dates, for instance start dates, but it won't let me do that for the other dates in the report. This is problematic because I'm trying to see employee starts and exits by fiscal year, including contract starts, contract ends, promotions, etc. by fiscal year too.
How can I get all of my different report dates to align with my defined fiscal year in my calendar table? Or do I need to create a new calendar table for every single one of these dates in the report?
