SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Table_1(
   StockTransferId      INTEGER  NOT NULL
  ,CompanyMasterId      INTEGER  NOT NULL
  ,BranchGodownMasterId INTEGER  NOT NULL
  ,DocumentNo           INTEGER  NOT NULL
  ,DocumentDate         DATE  NOT NULL
  ,Itg_Tiles_SizeInMM   VARCHAR(12) NOT NULL
  ,Itg_Tiles_Design     VARCHAR(12) NOT NULL
  ,Itg_Tiles_Grade      VARCHAR(4)
  ,Quantity             INTEGER  NOT NULL
  ,ProductionQty        NUMERIC(5,2) NOT NULL
);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20294,2,3,282,'2018-12-21','300 X 600','BERGAMO GRIS',NULL,1250,0.00);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20294,2,3,282,'2018-12-21','300 X 600','CANCUN BEIGE','COM',8,5.06);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20294,2,3,282,'2018-12-21','300 X 600','CANCUN BEIGE','GOLD',150,94.94);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20294,2,3,282,'2018-12-21','396 X 396','BARSILONA',NULL,5650,83.37);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20294,2,3,282,'2018-12-21','396 X 396','BARSILONA','COM',6,0.09);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20294,2,3,282,'2018-12-21','396 X 396','BARSILONA','GOLD',1116,16.47);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20294,2,3,282,'2018-12-21','396 X 396','BARSILONA','UTL',5,0.07);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20294,2,3,282,'2018-12-21','396 X 396','DRAGO',NULL,50,83.33);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20294,2,3,282,'2018-12-21','396 X 396','DRAGO','GOLD',10,16.67);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','BEIGE',NULL,7335,90.66);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','BEIGE','COM',27,0.33);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','BEIGE','INTL',721,8.91);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','BEIGE','OTC',8,0.10);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','BLANCO',NULL,45990,96.33);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','BLANCO','INTL',1533,3.21);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','BLANCO','OTC',218,0.46);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','BRANCA','COM',280,8.26);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','BRANCA','INTL',3005,88.67);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','BRANCA','OTC',104,3.07);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','BROWN',NULL,7720,90.94);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','BROWN','COM',35,0.41);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','BROWN','INTL',734,8.65);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','CUPRA',NULL,45,91.84);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','CUPRA','INTL',4,8.16);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','GRIGIO',NULL,8970,90.91);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','GRIGIO','COM',56,0.57);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','GRIGIO','INTL',841,8.52);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','ROSSO',NULL,43072,91.00);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','ROSSO','INTL',3974,8.40);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','300X300X10MM','ROSSO','OTC',286,0.60);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','600X600X10MM','CALDI BIANCO',NULL,100,80.65);
INSERT INTO Table_1(StockTransferId,CompanyMasterId,BranchGodownMasterId,DocumentNo,DocumentDate,Itg_Tiles_SizeInMM,Itg_Tiles_Design,Itg_Tiles_Grade,Quantity,ProductionQty) VALUES (20296,1,4,250,'2018-12-22','600X600X10MM','CALDI BIANCO','COM',24,19.35);

32 rows affected

SELECT
    StockTransferId
  , CompanyMasterId
  , BranchGodownMasterId
  , MAX( DocumentDate )                                              as DocumentDate
  , Itg_Tiles_SizeInMM
  , Itg_Tiles_Design

, SUM( CASE WHEN Itg_Tiles_Grade IS NULL THEN ProductionQty END )  AS ProductionBlank
  , SUM( CASE WHEN Itg_Tiles_Grade = 'INTL' THEN ProductionQty END ) AS ProductionINTL
  , SUM( CASE WHEN Itg_Tiles_Grade = 'COM' THEN ProductionQty END )  AS ProductionCOM
  , SUM( CASE WHEN Itg_Tiles_Grade = 'GOLD' THEN ProductionQty END ) AS ProductionGOLD
  , SUM( CASE WHEN Itg_Tiles_Grade = 'UTL' THEN ProductionQty END )  AS roductionUTL
  , SUM( CASE WHEN Itg_Tiles_Grade = 'OTC' THEN ProductionQty END )  AS ProductionOTC
  , SUM( ProductionQty )                                             AS ProductionTOTAL

, SUM( CASE WHEN Itg_Tiles_Grade IS NULL THEN Quantity END )       AS Qtyblank
  , SUM( CASE WHEN Itg_Tiles_Grade = 'INTL' THEN Quantity END )      AS QtyINTL
  , SUM( CASE WHEN Itg_Tiles_Grade = 'COM' THEN Quantity END )       AS QtyCOM
  , SUM (CASE WHEN Itg_Tiles_Grade = 'GOLD' THEN Quantity END)       AS QtyGOLD
  , SUM (CASE WHEN Itg_Tiles_Grade = 'UTL' THEN Quantity END)        AS QtyUTL
  , SUM (CASE WHEN Itg_Tiles_Grade = 'OTC' THEN Quantity END)        AS QtyOTC
FROM table_1
GROUP BY
    StockTransferId
  , CompanyMasterId
  , BranchGodownMasterId
  , Itg_Tiles_SizeInMM
  , Itg_Tiles_Design
;

StockTransferId	CompanyMasterId	BranchGodownMasterId	DocumentDate	Itg_Tiles_SizeInMM	Itg_Tiles_Design	ProductionBlank	ProductionINTL	ProductionCOM	ProductionGOLD	roductionUTL	ProductionOTC	ProductionTOTAL	Qtyblank	QtyINTL	QtyCOM	QtyGOLD	QtyUTL	QtyOTC
20294	2	3	21/12/2018 00:00:00	300 X 600	BERGAMO GRIS	0.00	null	null	null	null	null	0.00	1250	null	null	null	null	null
20294	2	3	21/12/2018 00:00:00	300 X 600	CANCUN BEIGE	null	null	5.06	94.94	null	null	100.00	null	null	8	150	null	null
20294	2	3	21/12/2018 00:00:00	396 X 396	BARSILONA	83.37	null	0.09	16.47	0.07	null	100.00	5650	null	6	1116	5	null
20294	2	3	21/12/2018 00:00:00	396 X 396	DRAGO	83.33	null	null	16.67	null	null	100.00	50	null	null	10	null	null
20296	1	4	22/12/2018 00:00:00	300X300X10MM	BEIGE	90.66	8.91	0.33	null	null	0.10	100.00	7335	721	27	null	null	8
20296	1	4	22/12/2018 00:00:00	300X300X10MM	BLANCO	96.33	3.21	null	null	null	0.46	100.00	45990	1533	null	null	null	218
20296	1	4	22/12/2018 00:00:00	300X300X10MM	BRANCA	null	88.67	8.26	null	null	3.07	100.00	null	3005	280	null	null	104
20296	1	4	22/12/2018 00:00:00	300X300X10MM	BROWN	90.94	8.65	0.41	null	null	null	100.00	7720	734	35	null	null	null
20296	1	4	22/12/2018 00:00:00	300X300X10MM	CUPRA	91.84	8.16	null	null	null	null	100.00	45	4	null	null	null	null
20296	1	4	22/12/2018 00:00:00	300X300X10MM	GRIGIO	90.91	8.52	0.57	null	null	null	100.00	8970	841	56	null	null	null
20296	1	4	22/12/2018 00:00:00	300X300X10MM	ROSSO	91.00	8.40	null	null	null	0.60	100.00	43072	3974	null	null	null	286
20296	1	4	22/12/2018 00:00:00	600X600X10MM	CALDI BIANCO	80.65	null	19.35	null	null	null	100.00	100	null	24	null	null	null

Warning: Null value is eliminated by an aggregate or other SET operation.