Need to show dublicate count in pivot table

[settu_periasamy]

I need to show the dublicate count in the pivot table. please see the below screen shot.

Base Table
Org	cust_name	Number	Condition
10	Cust1	1234	Fixed
10	Cust1	1234	Discount
10	Cust1	0000.49	Fixed
10	Cust1	00000	Discount
10	Cust1	01-4050	Discount
10	Cust1	0158	Discount
10	Cust1	017	Discount
10	Cust1	0170B	Discount
10	Cust1	0182	Fixed
10	Cust1	0182	Discount
10	Cust1	0189A	Discount
10	Cust1	02186.0250	Fixed
10	Cust1	-02267	Fixed
10	Cust1	026002	Discount
10	Cust1	02739.0250	Fixed
10	Cust1	-0281	Discount
10	Cust1	-0283	Discount
10	Cust1	-0284	Discount
10	Cust1	03	Discount
10	Cust1	03	Fixed

Out put should be like the below. if the Number is dublicate, i need to show the total count in Discount and Fixed.

Count
Org	cust_name	Number	Discount	Fixed
10	Cust1	03	2	2
10	Cust1	1234	2	2
10	Cust1	0000.49		1
10	Cust1	00000	1
10	Cust1	01-4050	1
10	Cust1	0158	1
10	Cust1	017	1
10	Cust1	0170B	1
10	Cust1	0182	2	2
10	Cust1	0189A	1
10	Cust1	02186.0250		1
10	Cust1	-02267		1
10	Cust1	026002	1
10	Cust1	02739.0250		1
10	Cust1	-0281	1
10	Cust1	-0283	1
10	Cust1	-0284	1

Thank you.

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.