Hi All,
Am trying to identify the growth between the previous year RQTR vs current year RQTR using below given script. Am getting exact growth percentage while using the script in straight table but am not getting growth percentage in Combo chart using yearmonth as dimension...
((sum({$<DATAPERIOD={">=$(=date(addmonths(date#(max(DATAPERIOD),'YYYYMM'),-2),'YYYYMM'))<=$(=max(DATAPERIOD))"},LAB_DESC={'SSSS'}>}NVALUE)
-
sum({<DATAPERIOD={">=$(=date(addmonths(Addyears(date#(max(DATAPERIOD),'YYYYMM'),-1),-2),'YYYYMM'))<=$(=date(Addyears(date#(max(DATAPERIOD),'YYYYMM'),-1),'YYYYMM'))"},LAB_DESC={'SSSS'}>}NVALUE))
/
(sum({<DATAPERIOD={">=$(=date(addmonths(Addyears(date#(max(DATAPERIOD),'YYYYMM'),-1),-2),'YYYYMM'))<=$(=date(Addyears(date#(max(DATAPERIOD),'YYYYMM'),-1),'YYYYMM'))"},LAB_DESC={'SSSS'}>}NVALUE)))
*100
Regards,
Jegadeesan G
