No requirement is little different. I am using cross Tab and I want to filter it there and it should change automatically for every current month. like if May is (Current month) then it should show Feb-mar-apr(3 previous months) and Jun-July(2 future months) So in addition likewise it should change automatically for every current month without doing any changes. Right now. I created two fields min date and max date with code intnx('month',input(metric_month,anydtdte20.),-3) as min_date format=date9., intnx('month',input(metric_month,anydtdte20.),+2) as max_date format=date9., and when i am filtering it in cross tab using "month between incl max & min" its not filtering the months       Thanks Vish ... View more

Hi,    I tried but not getting it, how to do it as I don't have any reporting date and my month is in char format to convert it to date, I am using following code  input(month, dtdtm.) as new_month format=dtdate9., and how I will create the month identifier for it?   I am new to it    Thanks  vish ... View more