SQL & PL/SQL

Hi,

i have data something like below.

10       A         X       100        100000       ABCD

10       B         A       200         200000      EFGH

10       C         A       300         3000000    IJKL

20       D        Y        100         4000000    MNOP

20       E        D        200         5000000    QRST

20       F        D        300         6000000    UVWX

in above example first four columns are dimensional columns and last column is fact column..

I have joined multiple tables and finally get the data some thing like above and cant do the group by on some columns to get the required output like below.

Now i want to get data something like below with sql's.

10     100000     200000     3000000  

please suggest how can i get the correct data format.

Thanks in Advance..