title: Tableau creating a calculated percentage (non-aggregate) based on an aggregated total
body: <p>Either I am the first person to ever need to display percentages in Tableau or I do not know what to search for! I highly suspect it is the latter...</p>
  
  <p>I believe what I am attempting to ask is how to make a calculated non-aggregated field by dividing by an aggregated number. Although I would prefer just to be able to display the percentages instead of a whole number.</p>
  
  <p>This is how I would do it in Excel:</p>
  
  <p><a href="https://i.stack.imgur.com/uRPts.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uRPts.png" alt="enter image description here"></a></p>
  
  <p>The data that already exists is Column A and B. In Tableau these would be non-aggregated. What I need to do in Tableau is to generate what is column C (also non-aggregated) because it does not exist in my data. In excel, all I did to get the aggregate number (total) of column B was:</p>
  
  <p><code>sum(B1:B4)</code></p>
  
  <p>And for the column C:</p>
  
  <p><code>=B1/$B$5</code></p>
  
  <p>But I can't seem to do this at all in Tableau. When I try to use the same syntax, I get an error message: "Cannot mix aggregate and non-aggregate arguments with this function."</p>