Removing duplicates in pivot table totals

[GNB]

I have the below data set which analyses product performance.

Excel Workbook
	A	B	C	D	E
1	DATE	purchase_type	country	order_id	Product Name
2	2/04/2011	PURCHASE	us	12345	A
3	2/04/2011	PURCHASE	us	25498	B
4	2/04/2011	PURCHASE	us	12345	C
5	2/04/2011	PURCHASE	us	68987	A
6	2/04/2011	PURCHASE	us	87431	B
7	2/04/2011	PURCHASE	au	64677	C
Sheet1

Excel 2007



When I pull this into a pivot table I am getting a total of 6 but what I really want is an overall total of 5 (i.e. do not want duplicates) when I look at summary data but the total of 6 when I look by product.

Can this be done in a Pivot table or am I going to need to get a bit more creative?

Cheers.