title: Wrong Percentage of Subtotal
body: <p>I'm having an issue with tables calculations in tableau. I've got sales per manager and the target. I wanna have a calculation of the targets achievement. 
  That's what my data looks like and the percentage I wanna get: </p>
  
  <p><a href="https://i.stack.imgur.com/j4AZB.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/j4AZB.png" alt="enter image description here"></a></p>
  
  <p>Unfortunately, Tableau sums up the percentage and gives me the following results: </p>
  
  <p><a href="https://i.stack.imgur.com/J6QrZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/J6QrZ.png" alt="enter image description here"></a></p>
  
  <p>Target columns is a calculated field. E.g. </p>
  
  <pre><code>IF [Manager Name] =    "Manager 1" THEN "190000" 
  </code></pre>
  
  <p>The % columns is a calculated field and calculated as the following: </p>
  
  <pre><code> FLOAT([Profit])  / FLOAT([Target]) 
  </code></pre>
  
  <p>I tried to play with Table Calculations but it never worked. </p>