SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Create table mytbl 
(Branch varchar(10),
 CustCode varchar(10),
 Name varchar(10),
 Address varchar(10),
 MarketingCode varchar(10),
 CCVal varchar(10),
 Tot1 int,
 Tot2 int,
 Tot3 int
 )
INSERT INTO mytbl (Branch,CustCode,Name,Address,MarketingCode,CCVal,Tot1,Tot2,Tot3) 
       VALUES ('1','5001','MY C NAME','SA','12','10',100,0,0)

INSERT INTO mytbl (Branch,CustCode,Name,Address,MarketingCode,CCVal,Tot1,Tot2,Tot3) 
       VALUES ('1','5001','MY C NAME','SA','13','5',0,300,0)

INSERT INTO mytbl (Branch,CustCode,Name,Address,MarketingCode,CCVal,Tot1,Tot2,Tot3) 
       VALUES ('1','5001','MY C NAME','SA','15','8',50,0,0)


INSERT INTO mytbl (Branch,CustCode,Name,Address,MarketingCode,CCVal,Tot1,Tot2,Tot3) 
       VALUES ('1','5001','MY C NAME2','SA','15','8',50,0,0)
       
INSERT INTO mytbl (Branch,CustCode,Name,Address,MarketingCode,CCVal,Tot1,Tot2,Tot3) 
       VALUES ('1','5001','MY C NAME','SA2','15','8',50,0,0)
       
INSERT INTO mytbl (Branch,CustCode,Name,Address,MarketingCode,CCVal,Tot1,Tot2,Tot3) 
       VALUES ('1','5001','MY C NAME2','SA2','15','8',50,0,0)
6 rows affected

SELECT * FROM mytbl


Branch
CustCode
Name
Address
MarketingCode
CCVal
Tot1
Tot2
Tot3


1
5001
MY C NAME
SA
12
10
100
0
0

1
5001
MY C NAME
SA
13
5
0
300
0

1
5001
MY C NAME
SA
15
8
50
0
0

1
5001
MY C NAME2
SA
15
8
50
0
0

1
5001
MY C NAME
SA2
15
8
50
0
0

1
5001
MY C NAME2
SA2
15
8
50
0
0


Print 'CustCode GROUP BY';
SELECT   Branch, CustCode, 
         SUM(Tot1) As t1,
         SUM(Tot2) As t2,
         SUM(Tot3) As t3 
from  mytbl 
GROUP BY Branch, CustCode 

--WITH ROLLUP


Branch
CustCode
t1
t2
t3


1
5001
300
300
0


CustCode GROUP BY


Print 'CustCode GROUP BY';
SELECT   Branch, CustCode, 
         SUM(Tot1) As t1,
         SUM(Tot2) As t2,
         SUM(Tot3) As t3 
from  mytbl 
GROUP BY GROUPING SETS (Branch, CustCode, ())


Branch
CustCode
t1
t2
t3


null
5001
300
300
0

null
null
300
300
0

1
null
300
300
0


CustCode GROUP BY


Print 'CustCode GROUP BY - GROPING SETS';
SELECT   Branch, CustCode, 
         SUM(Tot1) As t1,
         SUM(Tot2) As t2,
         SUM(Tot3) As t3 
from  mytbl 
GROUP BY GROUPING SETS (ROLLUP(Branch, CustCode))


Branch
CustCode
t1
t2
t3


1
5001
300
300
0

1
null
300
300
0

null
null
300
300
0


CustCode GROUP BY - GROPING SETS


Print 'CustCode GROUP BY - GROPING SETS';
SELECT   Branch, CustCode, 
         SUM(Tot1) As t1,
         SUM(Tot2) As t2,
         SUM(Tot3) As t3 
from  mytbl 
GROUP BY GROUPING SETS (ROLLUP(Branch, CustCode), CUBE(Branch, CustCode))


Branch
CustCode
t1
t2
t3


1
5001
300
300
0

null
5001
300
300
0

null
null
300
300
0

1
5001
300
300
0

1
null
300
300
0

null
null
300
300
0

1
null
300
300
0


CustCode GROUP BY - GROPING SETS


Print 'CustCode,name GROUP BY';
SELECT   Branch, CustCode, Name,
         SUM(Tot1) As t1,
         SUM(Tot2) As t2,
         SUM(Tot3) As t3 
from  mytbl 
GROUP BY Branch, CustCode, Name


Branch
CustCode
Name
t1
t2
t3


1
5001
MY C NAME
200
300
0

1
5001
MY C NAME2
100
0
0


CustCode,name GROUP BY


Print 'CustCode,name GROUP BY - GROPING SETS';
SELECT   Branch, CustCode, name,
         SUM(Tot1) As t1,
         SUM(Tot2) As t2,
         SUM(Tot3) As t3 
from  mytbl 
GROUP BY GROUPING SETS (ROLLUP(Branch, CustCode, name))


Branch
CustCode
name
t1
t2
t3


1
5001
MY C NAME
200
300
0

1
5001
MY C NAME2
100
0
0

1
5001
null
300
300
0

1
null
null
300
300
0

null
null
null
300
300
0


CustCode,name GROUP BY - GROPING SETS


Print 'CustCode,name GROUP BY - GROPING SETS';
SELECT   Branch, CustCode, name,
         SUM(Tot1) As t1,
         SUM(Tot2) As t2,
         SUM(Tot3) As t3 
from  mytbl 
GROUP BY GROUPING SETS (ROLLUP(Branch, CustCode, name), CUBE(Branch, CustCode, name))


Branch
CustCode
name
t1
t2
t3


1
5001
MY C NAME
200
300
0

null
5001
MY C NAME
200
300
0

null
null
MY C NAME
200
300
0

1
5001
MY C NAME2
100
0
0

null
5001
MY C NAME2
100
0
0

null
null
MY C NAME2
100
0
0

null
null
null
300
300
0

1
5001
MY C NAME
200
300
0

1
5001
MY C NAME2
100
0
0

1
5001
null
300
300
0

null
5001
null
300
300
0

null
null
null
300
300
0

1
null
MY C NAME
200
300
0

1
null
MY C NAME2
100
0
0

1
null
null
300
300
0

1
5001
null
300
300
0

1
null
null
300
300
0


CustCode,name GROUP BY - GROPING SETS
Branch	CustCode	Name	Address	MarketingCode	CCVal	Tot1	Tot2
1	5001	MY C NAME	SA	12	10	100	0
1	5001	MY C NAME	SA	13	5	0	300
1	5001	MY C NAME	SA	15	8	50	0
1	5001	MY C NAME2	SA	15	8	50	0
1	5001	MY C NAME	SA2	15	8	50	0
1	5001	MY C NAME2	SA2	15	8	50	0
Branch	CustCode	t1	t2
1	5001	300	300
null	5001	300	300
null	null	300	300
1	5001	300	300
1	null	300	300
null	null	300	300
1	null	300	300