Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
See attached qvw.