Pivot Table with Problem with expressions

[BootCam]

I Have a scenario like this,

I have to calculate the unbalanced trades.

Based on the Trade Numbers and Each trades has different allocations and each allocations has different cost amount and market amount.

What i am suppose to do is, get the number of unbalanced Trades based on the calculation given in the Example file. I have to Replicate

example file in qlikview. Example-Copy is the example data file.

Any help regarding this problem would be highly appreciated.

Thanks,

Sk

[#2]

Do you have only two trades for each Parent trade ?

[BootCam]

Hi Srikanth,

Yes, One is in Buy side and other is in Sell side.

Thanks,

Sk

[BootCam]

Hi,

Is there anyone who can help me out with this problem?

Thanks,

Sk