2 Replies Latest reply: Apr 21, 2012 8:56 AM by O.Developer RSS

    Matrix  Report  - Add a formula colum

    O.Developer
      Hi

      I created matrix report with column id, year, total....
      now my matrix report output s looks like below


      cust id     Year 2001-      Year 2002
      001 1000     1500
      002     2000     3000
      003 5000 4000

      Now I want to find which year is more for each customer and that should print next to year 2002, so the new out put should be

      cust id     Year 2001-      Year 2002 Diff-
      001 1000     1500 500
      002     2000     3000 3000
      003 5000 4000 -1000

      Please help how i will include formual in matrix report - Oracle reports 10g

      Thanks