sALES FOR PAST ONE YEAR

[#1]

hI i HAVE A COLUMN CALLED REGN_DATE , I EXTRACT MONTH,YEAR AND ALSO MONTHYEAR IN TWO DIFFERENT COLUMNS. i AM SHOWING A GRAPH OF NUMBER OF REGISTERATION PER MONTH. NOW IF I SELECT JAN2013 I SHOULD GET DATA FROM JAN2012 TO JAN2013 , HOW CAN I MODIFY MY =COUNT(REGISTERED_ID) FORMULA TO GET THAT DONE !!.

URGENT

[er_mohit]

Try this

count({$< REGN_DATE = {">=$(=MonthStart(Max( REGN_DATE),-12))<=$(=MonthEnd(Max( REGN_DATE)))"},Year=,Month=>}REGISTERED_ID)