| Filter: Performance Trend |
| CASE [Performance Scope] WHEN “CM_vs_PM” THEN IF [Period: Months to Current Month] <= 0 AND [Period: Months to Current Month] >= -12 THEN “Y” ELSE “N” END WHEN “CM_vs_PY” THEN IF [Main Date: Year] = [Current Year] OR [Main Date: Year] = [Current Year]-1 THEN “Y” ELSE “N” END WHEN “ACT_vs_TGT” THEN IF [Main Date: Year] = [Current Year] THEN “Y” ELSE “N” END WHEN “CYTD_vs_PYTD” THEN IF [Main Date: Year] = [Current Year] OR [Main Date: Year] = [Current Year]-1 THEN “Y” ELSE “N” END WHEN “YTDACT_vs_YTDTGT” THEN IF [Main Date: Year] = [Current Year] THEN “Y” ELSE “N” END WHEN “NONE” THEN NULL END |
Pilih Filter:Performance Trend: Y pada filter