6 Replies Latest reply on Dec 4, 2015 12:45 PM by Hesh

    Sum over two subject area results

    Hesh

      Hi,

       

      OBIEE 10g.

       

      I have to club two reports from two subject areas into one and I am trying to use the results from two subject areas (Union ) functionality in Answers.

      But the problem is its producing two records each for one SA. I need a sum over that, like following.

       

      Year      Sales_Amt       Stock_Qty

      2014      108123             2343

       

      but currently its displaying like following.

       

      Year      Sales_Amt       Stock_Qty

      2014      0                     2343

      2014      108123             0



      Appreciate your help on this.


      Thanks you,

      Hesh