3 Replies Latest reply on Sep 14, 2015 1:53 PM by SriniVEERAVALLI

    How to add and subtract selected rows and groups in obiee Analytics.?

    SanthoshSreshta

      Hi All,

       

      How to subtract some specific rows in the report as such below mentioned scenario.

       

       

      idamount
      A20
      B30
      sub1(A+B)50
      C40
      D50
      sub2(C+D)90
      E60
      F70
      sub3(E+F)130
      sub4(sub1-sub2)- 40
      grand_total (A+B+C+D+E+F)270

       

      I am able to get the subtotal (sub1,sub2,sub3) but not able to get sub4.

      I have used CASE statement to get those subtotals, but can anyone help me in getting sub4.

      I have tried using calculated item for that, I am able to get the value but the content is also been repeating as

      please excuse me for the naming conventions which I have used differently in both table and image.

      Please help me sorting out. I dont want to display the violet colored highlighted in the above image, just only need the all subtotals.

       

      Thanks,

      Santhosh.