CREATE TABLE QTEMP/PIVOTCOUNT AS (
SELECT CHAR(DATE, ISO) DATE,
           COUNT(QUANTITY_ONE   )  QUANTITY_ONE   ,
           COUNT(QUANTITY_TWO   )  QUANTITY_TWO   ,
           COUNT(QUANTITY_THREE )  QUANTITY_THREE ,
           COUNT(QUANTITY_TOTAL )  QUANTITY_TOTAL ,
           COUNT(AMOUNT_ONE     )  AMOUNT_ONE     ,
           COUNT(AMOUNT_TWO     )  AMOUNT_TWO     ,
           COUNT(AMOUNT_THREE   )  AMOUNT_THREE   ,
           COUNT(AMOUNT_TOTAL   )  AMOUNT_TOTAL
FROM (
SELECT DATE
,CASE WHEN REGION = 'one' THEN QUANTITY  END QUANTITY_ONE
,CASE WHEN REGION = 'two' THEN QUANTITY  END QUANTITY_TWO
,CASE WHEN REGION='three' THEN QUANTITY  END QUANTITY_THREE
, QUANTITY                                   QUANTITY_TOTAL
,CASE WHEN REGION = 'one' THEN AMOUNT  END AMOUNT_ONE
,CASE WHEN REGION = 'two' THEN AMOUNT  END AMOUNT_TWO
,CASE WHEN REGION='three' THEN AMOUNT  END AMOUNT_THREE
,                               AMOUNT     AMOUNT_TOTAL
                 FROM PIVOTP ) AS PIVOT
GROUP  BY DATE
) WITH DATA
;
INSERT INTO QTEMP/PIVOTCOUNT
SELECT 'TOTAL'             ,
           COUNT(QUANTITY_ONE   )  QUANTITY_ONE   ,
           COUNT(QUANTITY_TWO   )  QUANTITY_TWO   ,
           COUNT(QUANTITY_THREE )  QUANTITY_THREE ,
           COUNT(QUANTITY_TOTAL )  QUANTITY_TOTAL ,
           COUNT(AMOUNT_ONE     )  AMOUNT_ONE     ,
           COUNT(AMOUNT_TWO     )  AMOUNT_TWO     ,
           COUNT(AMOUNT_THREE   )  AMOUNT_THREE   ,
           COUNT(AMOUNT_TOTAL   )  AMOUNT_TOTAL
FROM (
SELECT DATE
,CASE WHEN REGION = 'one' THEN QUANTITY END QUANTITY_ONE
,CASE WHEN REGION = 'two' THEN QUANTITY END QUANTITY_TWO
,CASE WHEN REGION='three' THEN QUANTITY END QUANTITY_THREE
, QUANTITY                                  QUANTITY_TOTAL
,CASE WHEN REGION = 'one' THEN AMOUNT END AMOUNT_ONE
,CASE WHEN REGION = 'two' THEN AMOUNT END AMOUNT_TWO
,CASE WHEN REGION='three' THEN AMOUNT END AMOUNT_THREE
,                              AMOUNT     AMOUNT_TOTAL
                 FROM PIVOTP ) AS PIVOT