Hello All,
I need to create a straight table where Createdate will be Dimention and count of records should be the expression , but I have to count records based on a unique combination of YOA,Key and Reference.
So if a unique record is count in first month , it should not be counted in the consecutive months . Below is the sample data .
Kindly help.
| CreateDate | YOA | Key | Reference |
| 01/01/2016 | 2016 | ABC | 123 |
| 01/01/2016 | 2016 | ABC | 234 |
| 01/02/2016 | 2016 | ABC | 123 |
| 01/02/2016 | 2016 | XYZ | 789 |
| 01/02/2016 | 2016 | GHJ | 458 |
| 01/03/2016 | 2016 | TES | 123 |
Output expected
| CreateDate | Count | Cumulative Count |
| 01/01/2016 | 2 | 2 |
| 01/02/2016 | 1 | 3 |
| 01/03/2016 | 2 | 5 |
