Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please advise how to count no. of customer records buying any product on the same date .
| Customer | Product | Transaction_Date |
| A | xxx | 01/01/2020 |
| A | yyy | 01/01/2020 |
| A | zzz | 02/01/2020 |
| B | xxx | 01/01/2020 |
| B | yyy | 01/01/2020 |
| B | zzz | 01/01/2020 |
| B | xxx | 02/01/2020 |
| C | zzz | 01/01/2020 |
Expected result
| Customer | Transaction Date | Count |
| A | 01/01/2020 | 2 |
| A | 02/01/2020 | 1 |
| B | 01/01/2020 | 3 |
| B | 02/01/2020 | 1 |
| C | 01/01/2020 | 1 |
Thanks for reply ,
in one table there are no of date, no of SHOP NAME, NO Of REASON CODE
so iwant to Sum SCRAP COST having "same SHOP NAME ", "Same REASON CODE", & same "DATE " with this condition
hope you get it my requirement.
Thnks
sunil