Dimensiones:
FLETE,MES,AÑO,CLIENTE,DOCUMENTO,VENDEDOR


Metricas:
IMPORTE_FACT,VALOR_FLETE,%_FLETE,CAJAS,FLETE_POR_CAJA,UNIDADES,FLETE_POR_UNIDAD


Sentencia SQL:
select PAR7.AGDESCR,DMES,DYEAR,CLICOD,DNUM,PAR1.AGDESCR,DBRUTO-DDESC,DCOSTOFLETE,(DCOSTOFLETE/(DBRUTO-DDESC))*100,COMCAJA,(DCOSTOFLETE/COMCAJA),DPZAS,(DCOSTOFLETE/DPZAS) from FDOC
left join FCLI on FCLI.CLISEQ=FDOC.CLISEQ
left join FAG as PAR7 on PAR7.AGTNUM=FDOC.DPAR7
left join FAG as PAR1 on PAR1.AGTNUM=FDOC.DPAR1
left join FCOMENT on FCOMENT.COMSEQFACT=FDOC.DSEQ
where DESFACT=1 and DFECHA>=[MEMFDEL] and DFECHA<=[MEMFAL] and DCANCELADA=0