merge duplicate data and summing value with average price

Attached, I have created a pivot table using Power Pivot (Create Pivot by checking the Data Model Checkbox). My calculations for Average and Total do not agree with yours. I had Excel Pivot Table functions calculate. Not sure how you arrived at yours. Needed to create a DAX Measure for the Customer Nr and Invoice Nr.

Here is a tutorial on that: https://sfmagazine.com/post-entry/ju...a-pivot-table/

Excel 2016 (Windows) 32 bit

	B	C	D	E	F	G	H	I	J
9	CODE	BRAND	TYPE	ORIGIN	Cust Nr	Invoice Nr	Sum of QTY	Average of PRICE	Sum of TOTAL
10	AA-100	ASGL-VEN	SD-1	CCL1	CUS-100, CUS-101	INV1-BSJ4-1000, INV1-BSJ4-1001	20	75	1500
11	AA-101	VLG-FRE	SD-2	CCL2	CUS-102, CUS-103, CUS-104	INV1-BSJ4-1002, INV1-BSJ4-1003, INV1-BSJ4-1006	60	213.3333333	12400
12	AA-102	VMC-EZER	SD-3	CCL3	CUS-100	INV1-BSJ4-1000	5	100	500
13	AA-103	C-ZER	SD-4	CCL4	CUS-100	INV1-BSJ4-1004	5	20	100
14	AA-104	MM-FR	SD-5	CCL5	CUS-100	INV1-BSJ4-1005	5	30	150

Sheet: STOCK