Tengo el siguiente script, y donde dice Pivot manda error, favor ayuda.
Select "ItmsGrpNam",IFNULL("QUITO",0) "QUITO",IFNULL( "GUAYAQUIL",0) "GUAYAQUIL",IFNULL( "MANABI",0) "MANABI",IFNULL( "CUENCA",0) "CUENCA", IFNULL("QUITO",0)+IFNULL( "GUAYAQUIL",0)+ IFNULL("MANABI",0)+IFNULL( "CUENCA",0) "TOTAL"
from(SELECT T4."ItmsGrpNam", sum(Round(T0."LineTotal"*(1-IFNULL(T1."DiscPrcnt",0)/100),2)) "Neto", upper(LTRIM(RTRIM(T2."U_meg_sucursal"))) "sucursal"
FROM INV1 T0 INNER JOIN OINV T1 ON T0."DocEntry" = T1."DocEntry"
Left JOIN OSLP T2 on T1."SlpCode"=T2."SlpCode" left JOIN OITM T3 ON T0."ItemCode"=T3."ItemCode" left JOIN OITB T4 ON T3."ItmsGrpCod"=T4."ItmsGrpCod" left JOIN "@EXX_SUBFAMILIA" T5 ON T3."U_exx_SubFamilia" = T5."Code" Left JOIN OCRD T6 on T1."CardCode"=T6."CardCode"
Where T1."Canceled"='N' and T1."DocDate" Between "%0" and "%1" and T1."DocType" like '"%2"%' and T1."DocSubType" like '"%3"%' and T1."U_DOC_DECLARABLE" like '"%4"%'
group by T4."ItmsGrpNam", upper(LTRIM(RTRIM(T2."U_meg_sucursal")))
UNION
SELECT T4."ItmsGrpNam", sum(Round(-T0."LineTotal"*(1-IFNULL(T1."DiscPrcnt",0)/100),2)) "Neto", upper(LTRIM(RTRIM(T2."U_meg_sucursal"))) "sucursal"
FROM RIN1 T0 INNER JOIN ORIN T1 ON T0."DocEntry" = T1."DocEntry"
Left JOIN OSLP T2 on T1."SlpCode"=T2."SlpCode" Left JOIN OITM T3 ON T0."ItemCode"=T3."ItemCode" left JOIN OITB T4 ON T3."ItmsGrpCod"=T4."ItmsGrpCod" Left JOIN "@EXX_SUBFAMILIA" T5 ON T3."U_exx_SubFamilia" = T5."Code" Left JOIN OCRD T6 on T1."CardCode"=T6."CardCode"
Where T1."Canceled"='N' and T1."DocDate" Between "%0" and "%1" and T1."DocType" like '"%2"%' and T1."U_DOC_DECLARABLE" like '"%4"%'
group by T4."ItmsGrpNam", upper(LTRIM(RTRIM(T2."U_meg_sucursal")))
) AS "SourceTable"
PIVOT
(
sum("neto")
FOR "sucursal" IN ("QUITO", "GUAYAQUIL", "MANABI", "CUENCA")
) AS "PivotTable"
ORDER BY "total";
Gracias,