Please refer the data dump table below first.
| Category | Brand | Transaction Amount |
|---|---|---|
| Category1 | A | 10 |
| Category1 | B | 20 |
| Category1 | C | 30 |
| Category1 | A | 30 |
| Category2 | D | 40 |
| Category2 | E | 15 |
| Category2 | E | |
| Category2 | E | 15 |
This is the an example of the table i am working on. Now there 10-11 categories and each category has 6-7 unique brands and may/may not have transaction amount in front of them.
Now i want to print the brand names with highest sum of transaction amount per category in below result table.
This is easily doable by pivot by i want to achieve this using formula but unable to do so. Please help
This is the result table, where i should receive name of brands and sum of transaction. pls help
| Category | Brand | Sum of Transaction |
|---|---|---|
| Category1 | A | 40 |
| Category2 | D | 40 |
New contributor
Divij Goyal is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.