Calculated Field

  1. Bar Chart 
Total Sales Perf. –  Value (for trends) 
IF ATTR([Main Date: Month]) <= [Current Month] THEN  
CASE [Performance Scope]  
WHEN “CM_vs_PM” THEN NULL  
WHEN “CM_vs_PY” THEN [Total Sales  MTD   (Current Month) (for trends)]  
WHEN “ACT_vs_TGT” THEN  [Total Sales  MTD   (Current Month) (for trends)]  
WHEN “CYTD_vs_PYTD” THEN [Total Sales  YTD  (Current Year) (for trends)]  
WHEN “YTDACT_vs_YTDTGT” THEN [Total Sales  YTD  (Current Year) (for trends)]   
WHEN “NONE”  THEN NULL  
END  
END 
  1. Reference Line 
Total Sales Perf. – Reference (for trends) 
IF ATTR([Main Date: Month]) <= [Current Month] THEN  
CASE [Performance Scope]  
WHEN “CM_vs_PM” THEN NULL  
WHEN “CM_vs_PY” THEN [Total Sales  MTD   (Previous Year) (for trends)]  
WHEN “ACT_vs_TGT” THEN [Total Sales (Target)  MTD   (Current Month) (for trends)]  
WHEN “CYTD_vs_PYTD” THEN [Total Sales  YTD  (Previous Year) (for trends)]  
WHEN “YTDACT_vs_YTDTGT” THEN [Total Sales  YTD Target  (Current Year) (for trends)]  
WHEN “NONE”  THEN NULL  
END  
END 
  1. Color Marks 
Total Sales Perf. – Value vs Reference (for trends) 
ZN([Total Sales Perf. –  Value (for trends)]) – ZN([Total Sales Perf. – Reference (for trends)]) 
Was this page helpful?
Yes No

Leave a Reply

Your email address will not be published. Required fields are marked *