Função PIVOT

SELECT   
    *
FROM
    (SELECT
        *
    FROM(
    SELECT
        --CAB.CODTIPOPER,
        --TOPP.DESCROPER,
        CAB.CODCENCUS,
        CEN.DESCRCENCUS,
        --CAB.CODNAT,
        --NAT.DESCRNAT,
        UFS.UF,
        CAB.CODPARC AS QTD_CODPARC
    FROM
        TGFCAB CAB INNER JOIN TGFPAR PAR ON CAB.CODPARC = PAR.CODPARC
        INNER JOIN TSICID CID ON PAR.CODCID = CID.CODCID
        INNER JOIN TSIUFS UFS ON CID.UF = UFS.CODUF
        --INNER JOIN TGFTOP TOPP ON CAB.CODTIPOPER = TOPP.CODTIPOPER AND CAB.DHTIPOPER = TOPP.DHALTER
        INNER JOIN TSICUS CEN ON CAB.CODCENCUS = CEN.CODCENCUS
        --INNER JOIN TGFNAT NAT ON CAB.CODNAT = NAT.CODNAT
    WHERE
        CAB.CODTIPOPER = 700
        AND CAB.STATUSNOTA = 'L'
    GROUP BY
        --CAB.CODTIPOPER,
        --TOPP.DESCROPER,
        CAB.CODCENCUS,
        CEN.DESCRCENCUS,
        --CAB.CODNAT,
        --NAT.DESCRNAT,
        UFS.UF,
        CAB.CODPARC)XXX
    )UF
PIVOT
    (
    COUNT(DISTINCT QTD_CODPARC)
    FOR UF IN ('AC' AS AC,'PE' AS PE,'PB' AS PB,'RN' AS RN,'RS' AS RS,'RJ' AS RJ,'SP' AS SP,'BA' AS BA)
    )

QUANTIDADE DE VENDAS POR PARCEIRO/CENTRO DE RESULTADO/UF