Check if different row contains same value in columns

[FelipeG]

Hey guys! Hope you can help me with these problem i've been struggling with...

I have a table of operations:

Operation Num	Date	Company	Op. Type	Amount
1	09/10/2020	Apple	Buy	100
2	09/10/2020	Microsoft	Buy	200
2	09/10/2020	Intel	Sell	200
1	09/10/2020	Apple	Sell	100

I want to see all the operations that a company has done against themselves. In the example above I would end with:

1	09/10/2020	Apple	Buy	100
1	09/10/2020	Apple	Sell	100

I can't mess with the script in this particular case, needs to be some sort of Set Analysis operation or similar.

Would really appreciate some help! 

[Kushal_Chawda]

@FelipeG  try below

=sum({<Company=p({<[Op. Type]={'Buy'}>})*p({<[Op. Type]={'Sell'}>})>}Amount)

[FelipeG]

It didn't work. Shows the same value than sum(Amount). Any idea??