select * from (
SELECT 
 calendar_year_month_nm AS MONTHYEAR,
 DCS.CASE_STATUS_GROUP_CD AS CASESTATUS,
   FCT.CASE_CNT_1
FROM   EDW_DEV_1.F_IHSS_CASE_LIFECYCLE_EVENTS FCT
 INNER JOIN EDW_DEV_1.D_DATE DT ON DT.DATE_SK = FCT.DATE_SK
 INNER JOIN EDW_DEV_1.D_CASE_STATUS DCS ON DCS.CASE_STATUS_CD_NK = FCT.CASE_STATUS_CD_NK
WHERE DT.FIRST_DAY_IN_MONTH_DT>=ADD_MONTHS(SYSDATE,-13) AND DT.LAST_DAY_IN_MONTH_DT<=SYSDATE
)
 PIVOT
 (SUM(CASE_CNT_1) 
 for MONTHYEAR in 
 (    
 --SELECT distinct calendar_year_month_nm from D_DATE
 'Apr08','Jun08','Jul08' 
) 
 );

CREATE TABLE emp
( empno    NUMBER(4,0),
  ename    VARCHAR2(10 BYTE),
  job      VARCHAR2(9 BYTE),
  mgr      NUMBER(4,0),
  hiredate DATE,
  sal      NUMBER(7,2),
  comm     NUMBER(7,2),
  deptno   NUMBER(2,0)
); 

SELECT *
FROM (SELECT deptno,sal
      FROM emp
      WHERE deptno > 0
)
PIVOT (SUM(sal) AS SUM_AMOUNT FOR (deptno) 
IN (10 AS ACCOUNTING ,20 AS RESEARCH,30 AS SALES,40 AS OPERATIONS));