5 Replies Latest reply: Aug 27, 2013 3:57 AM by 205dde1d-1989-4f39-9044-7a0c1619ce92 RSS

    How to sum multiple columns with different grouping criteria

    205dde1d-1989-4f39-9044-7a0c1619ce92

      Currenly i am doing a project where i required to generate report which extracted from table. the table as per below

       

      CURRENCY_A    AMOUNT_A    CURRENCY_B    AMOUNT_B    CURRENCY_C    AMOUNT_C

      USD                      100                 EURO                  100              POUNDS             100

      EURO                    200                 POUNDS             200              USD                    200

      POUNDS               300                  USD                   300              EURO                  300

       

      My expectations is the grand total sum of (AMOUNT_A+AMOUNT_B+AMOUNT_C) group by the currency

      USD         :    

      EURO     :

      POUNDS    :

       

      Is it possible to perform this output in oracle alone?