Aggr on mulitple Dimensions

[sumeet-vaidya]

Dear All,

I have a scenario wherein I want to calculate Repeat cases based on (PolicyNo+Subtype+MonthYear)

Secenario 1 :    

PolicyNo	Subtype	Date	Month-Year
100	ABC	5/1/2017	May-17
100	ABC	5/1/2017	May-17
100	ABC	5/4/2017	May-17
100	ABC	5/6/2017	May-17
100	ABC	5/6/2017	May-17
100	ABC	5/7/2017	May-17

Output  

Month-Year	Repeat Count
May-17	3

Scenario 2:    

PolicyNo	Subtype	Date	Month-Year
100	ABC	5/1/2017	May-17
100	XYV	5/1/2017	May-17
100	PQR	5/4/2017	May-17

Output  

Month-Year	Repeat Count
May-17	0

Scenario 3:    

PolicyNo	Subtype	Date	Month-Year
100	ABC	5/1/2017	May-17
100	ABC	5/1/2017	May-17
100	PQR	5/4/2017	May-17

Output  

Month-Year	Repeat Count
May-17	0

Awaiting your reply.

Regards

Sumeet

[sumeet-vaidya]

Hi Sunny,

I re-wrote the same expression again and its working fine.

Thank you very much stalwar1‌...!!!

Regards

Sumeet