Show Largest and Average amounts same table

Mon, 15 Feb 2016 13:45:23 GMT

I have a requirement where i have below details:

I have to show the data in below format in straight table:

Basically i have to show the largest amount per company and the corresponding name of the person.

Average amount is just the average of all amounts per company.

I'm using this expression for calculating Largest amount:

MAX(AGGR([Amount]), Company, Person)

And this expression for Average amount:

AVG(AGGR([Amount]), Company, Person)

So, i'm getting the correct amounts but i'm not getting the corresponding Person Name, its coming as some random Person Name.

Can anyone help please?

topic Show Largest and Average amounts same table in QlikView