Eliminate some data

[shamsu_mk]

Hello team

Please find attached an excel table. I would like to have a Qlickview report by eliminating some data as per the below conditions. The items to be eliminated has been marked with yellow color

  The condition for elimination is followed.

Under one employee code,

If sum of WT=3000 and WT = 3005 is zero , the both line which represents 3000 and 3005 has to be eliminated,

     if not zero some color has to be  marked show the unmatched item

     if there is only one WT ( 3000 or 3005 ) no action required

Sorry, if my requirement confuses you, but please support me.

[shamsu_mk]

As marked in red some amounts are doublling in the report.

+

[mtucholski]

Hi,

I have loaded your data from .xlsx and put the code I wrote as a only load script. The result is as below. So I think it's something else that doubles the rows. You have to look through your load script. Note that my script loads only '0' marks.