Our customers do not always have the fiscal year starting on January 1, e.g. Period 1 could start on October 1. I want to select the YEARNOCAL and PERIODNOCAL, e.g. 2009 period 2, and I want the set analysis to select data from the first date held where PERIODNOCAL = 1 the the last date for the selected PERIODNOCAL.
I hope I have made my requirements clear. If not please let me know if anyone needs any further informaton.
This will work very well where the start date for the period is the 1st of the month. We have the scenario where periods can be 4 or 5 weeks in length rather than a calenar month, therfore the start date for period 1 if in July could be July 3rd