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 .
