thanks for quick reference and i am using time char cal year/month,period like and some thing i got it but i am not able to sure that its enough to crate a query.
if u dont mine can u give me a step by step procedure for it and i know that i have to offset but i dontknow how can and for which kf i have to offset.
thanks for who gave me help.
Well, in the new selection you will restrict with the cal year/month. (i think it is user entry variable). In the same selection drag the respective key figure too. On the period object use offsets. I hope this will help you. for step wise better take a look of the above link. Its not much complicated I believe. Please get back if you have any doubts.