TIBCO Spotfire - Insert Calculated Row
<p>I'm trying to insert rows to the table in Spotfire that are a sum of existing rows</p>

<p>Existing Table:</p>

<pre><code>ID  SUB_ID  Line  Quarter  Value   
1   123     A     1        1  
1   123     A     2        2  
1   123     B     1        3  
1   123     B     2        4  
1   124     A     1        5  
1   124     A     2        6  
1   124     B     1        7  
1   124     B     2        8  
2   123     A     1        9  
2   123     A     2        1  
2   123     B     1        2  
2   123     B     2        3  
2   124     A     1        4  
2   124     A     2        5  
2   124     B     1        6  
2   124     B     2        7  
</code></pre>

<p>Rows to Add:  </p>

<pre><code>ID  SUB_ID  Line  Quarter  Value (sum)
1   123     A     2        3  
1   123     B     2        7  
1   124     A     2        11  
1   124     B     2        15  
2   123     A     2        10  
2   123     B     2        5  
2   124     A     2        9  
2   124     B     2        13  
</code></pre>

<p>What is the best way to do this?</p>