I have a need to compare the current period with the last year December. The last year should change depends upon selection of current period ..for example
Essentially I have 3 columns
1. Current period year
2. Last year December period balance
3. Difference.
Suppose I take 2009.NOV as selected period it should compare with 2008.DEC
Suppose I select 2010.NOV it should compare with 2009.DEC.
EVTIM works with only offset periods..but how tell the system to select the last year December with above criteria?
Inputs are greately appreciated..