i have a requirement that when i enter the 1 in prompt i should get the last one year data , enter 2 should get the last 2 years data, enter 3 should get the last 3 years data.... there is any way to do this ,,,,,.......... pls post the answer ........... thanks
Assuming you have a dataitem for Actual year, you can use prompt value as parameter in parallelPeriod function to get the first year to be used.
With help of [Fistyear], [ActualYear] - Dataitems and the functions periodstodate and except, it should be possible to define a dataitem as needed.
Colt