Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Hi Sunny
This worked ...
Thanks
Bhupesh