How to get a particular item if it's ever been purchased?

[jasonwq]

For a table like the following:

Row#	ITEM	ENTRY_TYPE	QTY
1	A	OUTPUT	50
2	A	SALE	-8
3	B	PURCHASE	50
4	B	SALE	-8

If I filter for ENTRY_TYPE = PURCHASE it will only return ROW 3.

What I want to do is, if an ITEM has ever been PURCHASED, return that ITEM.

I want to see ITEM B, but I do not want to see ITEM A as it is not ever PURCHASED.

I wish to see ROW 3 and ROW 4 because ITEM B has been PURCHASED once.

[CNENFRNL · Accepted solution]