title: Combining IF statement to this Max LOD calc?
body: <p>I have a line graph of 12 months. Overlaid, I have a dual axis setup to show circles during each month to make it pop out more.</p>
  
  <p>Something I'm trying to attempt is showing which dept has the max sales for that month.</p>
  
  <p>For example, Month of March has $50k in sales, shown by the first line mark. In the second (circle mark) axis, I want to display a LOD calc to show the department who contributed to the most sales for the whole company, and then the circle will correspond to a color, which can be deciphered by a color legend.</p>
  
  <p>Here is what I have, but I know I need to place an if statement within the max function, I can't seem to figure that part out.</p>
  
  <p><code>{fixed:max({fixed[Department]:sum([Sales])})}</code> </p>