How to unique count?

[Anonymous]

I have these sets of data where the  masterdate is mapped to a master calendar.

CLAIM_TRANNO	Claim_Code	Claim_Type	CLAIMNUMBER	MasterDate	Own_Damaged_Count	Property_Damage_Count
1	PVCAF	OD_FEE	EIBV9074913PLM	01/12/2012	0	0
1	PVCRC	OD	EIBV9074913PLM	01/12/2012	1	0
2	PVCAF	OD_FEE	EIBV9074913PLM	01/01/2013	0	0
2	PVCRC	OD	EIBV9074913PLM	01/01/2013	1	0
3	PVCAF	OD_FEE	EIBV9074913PLM	01/01/2013	0	0
3	PVCRC	OD	EIBV9074913PLM	01/01/2013	1	0
4	PVCRC	OD	EIBV9074913PLM	01/03/2013	1	0
5	PVCRC	OD	EIBV9074913PLM	01/04/2013	1	0
5	PVTRC	TPPD	EIBV9074913PLM	01/04/2013	0	1
6	PVCRC	OD	EIBV9074913PLM	01/04/2013	1	0
6	PVTRC	TPPD	EIBV9074913PLM	01/04/2013	0	1
7	PVCRC	OD	EIBV9074913PLM	01/04/2013	1	0
8	PVTRC	TPPD	EIBV9074913PLM	01/06/2014	0	1
9	PVCAF	OD_FEE	EIBV9074913PLM	01/06/2014	0	0
9	PVCRC	OD	EIBV9074913PLM	01/06/2014	1	0
9	PVTRC	TPPD	EIBV9074913PLM	01/06/2014	0	1
10	PVCCT	OD	EIBV9074913PLM	01/06/2015	1	0
10	PVTRC	TPPD	EIBV9074913PLM	01/06/2015	0	1
11	PVCCT	OD	EIBV9074913PLM	01/06/2015	1	0
11	PVTRC	TPPD	EIBV9074913PLM	01/06/2015	0	1
13	PVCCT	OD	EIBV9074913PLM	01/06/2015	1	0
13	PVTRC	TPPD	EIBV9074913PLM	01/06/2015	0	1

For this claim number, i want to unique count the claim type based on OD and TPPD only.

The results should be like this in pivot table

                   Year Month

                    201202 201301 201304 201406 201506

no of claim        1                        1

How do i use set analysis to calculate this?

[Anonymous]

Hi peter, do you have any thoughts on this?@Peter Cammaert

[jonathandienst]

There are many OD and TTPD for the claim number. Do you mean that you want to count the first instances of the OD and TTPD for the claim?

If that is the case, you might want to add a flag field during your load to tag the first instances. Then you can simply add the flag values.

[Anonymous]

Yes. This is just from one claim number. What if i have more than one claim number with multiple transactions.

Yes i can do a tag at back end but just wonder if able to do this at the front end/designer stage using set analysis so i wouldn't have to load it again.