3 columns matched create report

Hi,
I have 4 columns [A CODE], [B TAG],[C CUSTOMER],[D AMOUNT] this are all duplicates in the sense of columns A,B,C I want them to group. if all 3 columns matches to more of them then generate report on next sheet with consolidated 4th column of Amount, and duplicates counts occurred

Any helps.

Quote:

---

CODE	TAG	CUSTOMER	AMOUNT
002	101	COSMOS	74027.00
002	101	COSMOS	20718.00
002	101	COSMOS	136600.00
002	102	SAM	40000.00
002	102	SAM	80250.00
002	102	SAM	1290.00
003	120	PLUTO	5432.00
003	120	PLUTO	5674.00
003	120	PLUTO	9000.00
009	140	CLICK IT	1450.00
009	140	CLICK IT	2346.00

---

REPORT SHEET

Quote:

---

CODE	TAG	CUSTOMER	TOTAL	COUNT
002	101	COSMOS	231345.00	3
002	102	SAM	121540.00	3
003	120	PLUTO	20106.00	3
009	140	CLICK IT	3796.00	2

---

In the attached, two solutions:
1. A basic pivot table
2. A power query solution.