I have 500 clients that use one of our products. When you setup our products there is a field label:
1. Start Base Month & Year
These can be different depending on the client but typically they are July, Aug, Sept of some year. What I want to do is to normalize my data for a application I am building. The clients enter 12 months of data. In order accomplish this I need to set the Start Base Month & Year to an Index of 1. Can this be done. Here is a sample of what the output can look like:
There cant be more than one Fiscal Year Begin Date per client. The reason I need this is to Fiscal Year Comparisons. I need to normalize all the months so I have a Fiscal Month 1,2,3,4,etc... and the month is relative to the Fiscal Year Start Date...so for client a, b, c can have different start dates (july, sept, jan)...Fiscal Month 1 should refer to july, sept, or Jan. depending on their FY setup. Does this help and if so can you show me how to accomplish this.