This content has been marked as final. Show 2 replies
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.