- Katılım
- 25 May 2018
- Mesajlar
- 1,377
- En iyi yanıt
- 13
- Puanları
- 113
- Konum
- İstanbul
- Web sitesi
- excelarsivi.com
- Ad Soyad
- Murat OSMA
- Office Versiyon
- Office 365 TR+EN
Aşağıdaki SQL sorgusu ile, Logo'da Satışların Ciro raporunu aylık pivot olarak alabilirsiniz.
[HIDEREPLYTHANKS]
[/HIDEREPLYTHANKS]
[HIDEREPLYTHANKS]
SQL:
SELECT [Cari Adı],
ISNULL([1],0)Oca, ISNULL([2],0)Sub, ISNULL([3],0)Mar, ISNULL([4],0)Nis, ISNULL([5],0)May, ISNULL([6],0)Haz,
ISNULL([7],0)Tem, ISNULL([8],0)Agu, ISNULL([9],0)Eyl, ISNULL([10],0)Eki, ISNULL([11],0)Kas, ISNULL([12],0)Ara,
ISNULL([1],0)+ISNULL([2],0)+ISNULL([3],0)+ISNULL([4],0)+ISNULL([5],0)+ISNULL([6],0)+
ISNULL([7],0)+ISNULL([8],0)+ISNULL([9],0)+ISNULL([10],0)+ISNULL([11],0)+ISNULL([12],0) TOPLAM
FROM ( select C.DEFINITION_ AS [Cari Adı], INV.NETTOTAL,MONTH(INV.DATE_)AY
FROM LG_001_CLCARD C INNER JOIN LG_001_01_INVOICE INV
ON INV.CLIENTREF=C.LOGICALREF WHERE C.ACTIVE=0 AND INV.CANCELLED=0 AND YEAR(DATE_)=2016
AND INV.GRPCODE=2 ) as TARKAN
PIVOT(SUM(NETTOTAL) FOR AY IN([1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12])) AS PIVOT_TABLOM
Son düzenleme:
