Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
count({$< REGN_DATE = {">=$(=MonthStart(Max( REGN_DATE),-12))<=$(=MonthEnd(Max( REGN_DATE)))"},Year=,Month=>}REGISTERED_ID)