This discussion is archived
5 Replies Latest reply: Aug 27, 2013 1:57 AM by 205dde1d-1989-4f39-9044-7a0c1619ce92 RSS

How to sum multiple columns with different grouping criteria

205dde1d-1989-4f39-9044-7a0c1619ce92 Newbie
Currently Being Moderated

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?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points