I have a requirement where i have below details:
| Company | Person | Amount |
| ABC | A | 100 |
| ABC | B | 200 |
| ABC | B | 300 |
| XYZ | C | 300 |
| XYZ | C | 100 |
| XYZ | D | 500 |
I have to show the data in below format in straight table:
| Company | Person | Largest Amount | Average Amount |
| ABC | B | 300 | 200 |
| XYZ | D | 500 | 300 |
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?
