title: Tableau - how do we calculate ratio of one dimension member to others?
body: <p>I'm looking to compute the ratio of one dimension member with others. My dataset looks something like this,</p>
  <pre><code>Name Role       City Country
  ABC  Admin      XYZ  PQR
  DEF  Marketing  ZZZ  YYY
  GHI  Admin      PPP  RRR
  </code></pre>
  <p>Assuming I create a Parameter with the list of roles, If I select Marketing, I need show there are 2 Admin people for every Marketing person in the company.</p>