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 🙂
