title: Oracle Apex: Dynamic Calculation in Classic Report
body: <p>I have an application where I have created the classic report based on SQL query</p>
  
  <pre><code>Select summary_id,  
  APEX_ITEM.HIDDEN(1,summary_id)||  
  APEX_ITEM.TEXT(2,attribute5) attribute5 
  from summary;
  </code></pre>
  
  <p>Here summary_id and attribute 5 are number data type.</p>
  
  <ol>
  <li><p>I have seven (7 rows) records, where 5th and 7th rows in the column are sub_total and total values. </p></li>
  <li><p>I want to dynamically calculate the sub_total and total based on change of values in previous rows.</p></li>
  <li><p>Row5th is total of 1st,2nd,3rd and 4th row and row7th is total of 1st,2nd,3rd,4th and 6th </p></li>
  </ol>
  
  <p>Please let me know if need to Provide any other information to understand the problem.</p>
  
  <p>Thank you.</p>
  
  <p><strong>Oracle apex 4.2 version</strong>.</p>