Filtered Calculation in Tableau
<p>I have a table which consists of the following:</p>

<blockquote>
  <p>Date | Region |Revenue Type| Revenue Amount |</p>
</blockquote>

<p>There are 20 Revenue Types (A,B,C....Goal), with the last type being a goal for  A, B, and C. </p>

<p>I'd like to be able to graph the sum of A, B, C against the Goal. The Goal would be on a Dual Axis. </p>

<p>Is there a way to create a calculated field for SUM(A,B,C) and contrast against the Goal in a single line graph? </p>