title: Spotfire - Finding the percentage contribution of each Cell
body: <p>I am trying to find the percentage contribution of each cell in a cross table in spotfire.</p>
  
  <p>The table looks like this</p>
  
  <pre><code>Group     Name     Score
  1         Andy     80
            Bill     70
            Charlie  90
  2         Andre    100
            Bob      60
            Clint    70
  </code></pre>
  
  <p>I want to make the table to show something like this</p>
  
  <pre><code>Group     Name     Score   Percentage
  1         Andy     80      33%
            Bill     70      29%
            Charlie  90      38%
  2         Andre    100     43%
            Bob      60      26%
            Clint    70      30%
  </code></pre>
  
  <p>Where each percentage is the score of each person divided by the total of the score in each group so for Andy = 80 / (80+70+90) = 33%</p>
  
  <p>My code so far is this </p>
  
  <pre><code>Count([Score]) / Count([Score]) OVER (Intersect(Parent([Group]),All([Name])))
  </code></pre>
  
  <p>I am not sure which part I get wrong. Please help.</p>