title: Display percent by category in tableau
body: <p>I have a dataset in tableau where I would like to show the percent of each category.</p>
  <p>Data</p>
  <pre><code>free    use type    date
  10      5   A1      1/1/2021
  20      1   A1      1/1/2021
  40      2   B2      1/1/2021
  60      3   B2      1/1/2021
  </code></pre>
  <p>Desired</p>
  <pre><code>   type      %
  
     A1      50%
     B2      50%
  </code></pre>
  <p>Doing</p>
  <p><a href="https://i.stack.imgur.com/UKvvw.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UKvvw.png" alt="enter image description here" /></a></p>
  <pre><code>SUM( [type] ) / SUM( [type] )
  </code></pre>
  <p>However, because 'type' is a string, the calculation is not successful.
  Is there a way to showcase a groupby and to display the percent?
  Any suggestion is appreciated</p>