Display text field dependent on the maximum value of another numeric field

[#1]

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

Company	sum(Price)	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