title: Interactive Report - aggregate sum of multiple columns from one table multiply by values from another Table
body: <p>I have a challenge in Oracle Apex - I would to sum multiple columns to give 3 extra rows namely points, Score, %score. There are more columns but I'm only choosing a few for now. <br>
  Below is an example structure of my data: <br></p>
  
  <pre><code>Town | Sector  |  Outside| Inside |Available|Price
  Roy-----Formal----0----------0----------1------0
  Kobus --Formal----0 ---------0--------- 1------0
  Wika ---Formal----0----------0--------- 1------0
  Mevo----Formal----1----------1----------1------0
  Hoch----Formal----1----------1----------1------1            
  Points------------2----------2----------5------1
  Score------------10---------10---------10------10
  %score-----------20---------20---------50------10
  </code></pre>
  
  <p>Each column has a constant weighting (which serves as a factor and it can change depending on the areas). In this case, the weighting for the areas are in the first row of the sector Formal: <br></p>
  
  <pre><code>Sector |Outside| Inside |Available|Price
  Formal----1----------1 ----------1-----1
  Informal--1----------0 ----------2-----1
  </code></pre>
  
  <p>I tried using the aggregate sum function in apex but it wont work because I need the factor in the other table. This is where my challenge began.</p>
  
  <p>To compute the rows below the report<br> 
  <strong>points</strong> = sum per column * weighting factor per column<br>
  <strong>Score</strong> = sum of no of shops visited (in this case its 5) * weighting factor per column<br>
  <strong>% score</strong> = points/Score * 100<br></p>
  
  <p>The report should display as described above. With the new computed rows below.<br>
  I kindly ask anyone to assist me with this challenge as I have tried searching for solutions but haven't come across any.<br></p>
  
  <p>Thanks a lot for your support in advance!! </p>