Keeping unique rows in a table

[#1]

Table 1:

Transaction reference number	Report status
'18818136SELL	N
'18818136SELL	U

I have a table with number of columns, two of which are 'transaction ref.no.' and 'report status'. There are a number of duplicate trans.ref.no. with stauts U and N but I only want to keep those with status N in the table.

How can I do this? I am new to qlik so don't have much idea.

Regards

[#2]

Hi Swuel,

Yes , i am referring to your code and it works as expected by the @abhi_kash .(who started the tread).Thankyou.

@abhi_kash ,Please mark as correct Answer if its works for you.