apex version? database version?
if you're on 11g, it sounds like you want the PIVOT command.
you should also post a simple CREATE TABLE and a few INSERT statements so others can test.
select null link
,report_date as datime
from ( select REPORT_DATE, NODE_NAME, STORAGE_AMOUNT_ALLOC
sum( storage_amount_alloc )
in ( 'Anole' "Anole", 'Fiji' "Fiji" ) -- rename columns here
where report_date between to_date('01-JAN-2013','DD-MON-YYYY') and to_date('01-JUN-2013','DD-MON-YYYY')
order by report_date asc