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

    Find average Profit overall Region & compare with particular State

    szymon.j

      Hello,

       

      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.