The title is not helpful so I will explain the situation better.
Imagine a table with the following fields
Company (A, B, C, ....)
Category (Phones, TVs, Computers,...)
Item (item1, item2, item3, ...)
Price( 100, 150, 160...)
I want to create a chart grouping information by Company
A 100,000 Phones
| | Category with biggest Price in the Company | sum(price) for biggest category |
---|
A | 100,000 | Phones | 40,000 |
B | 160,000 | TVs | 100,000 |
Question is:
how do I write the formula to get the column Category with biggest Price in the Company and sum(price) for biggest category.
I have tried a lot but I am not able to create a correct formula.
Thanks
Marco