Sum Field based on other two fields aggregated

[FelipeG]

Hello Qlik community !! 

I have a table consisting of 4 Fields: Date, Buyer, Seller, TotalAmount. 

My data consists of transactions between the buyers and sellers which can be interchangeable, in other words, entity X can appear both as seller and buyer. What i want to do is rank the buyers and sellers as a single entity  "Company" based on the Sum of the total amount, whether they acted as buyer or seller. 

For example supposing I have this values in my Table:

Table:

[ Date, Buyer, Seller, Total Amount 

  12/05/2020, Apple, Amazon, 2000

  13/05/2019, Amazon, Apple 2500

  01/01/2020, Apple, Microsoft, 1000

]

I want a table-chart that displays: (Rank, Company, TotalAmountTransactioned)

1 - Apple - 5500

2 - Amazon - 4500

3 - Microsoft -1000

Will really appreciate it if someone can help me 🙂

[Kushal_Chawda]

@FelipeG  is below same thread?

https://community.qlik.com/t5/New-to-Qlik-Sense/Sum-Field-based-on-other-two-fields-aggregated/td-p/...