2 Replies Latest reply on Apr 26, 2018 3:49 PM by Shinichiro Murakami

    Find average Profit overall Region & compare with particular State




      I have "State vs Profit" worksheet where show profit by State and using reference line indicate avg value overall State from chosen Region.


      I would like to distinguish by color which Profit State is under average profit from Region.



      I created calculation: SUM(IF [Date Filter CP] = True THEN [Profit] END)/COUNTD(IF [Date Filter CP] = True THEN [State] END) but is not works for particular State.