Select only Top Value for calculating the average

[#1]

Hi there,

I have the following table:

Date	Region	Person	Product	Sales
Jan	Europe	Adam	Banana	5000
Jan	Europe	Adam	Lemon	1000
Jan	Europe	Berta	Apple	3000
Feb	Europe	Adam	Banana	4500
Feb	Europe	Adam	Lemon	595
Feb	Europe	Berta	Apple	3250
Feb	Europe	Berta	Cherries	500

and so on.

All these Values I display in a Table Chart, which works totally fine.

I also want a line chart when I am selecting a certain Region, e.g. Europe where only the top selling products for each Person are displayed. I am struggling with Set analysis, so I hope somebody is capable of helping me in this case.

As a dimension I used: Date, Region and Person.

Thanks a lot in advance.

Alex

[jonathandienst]

With those dimensions, one of these expressions will work:

FirstSortedValue(Product, -Sales)

or

FirstSortedValue(Product, -Sum(Sales))

HTH

Jonathan

[#3]

Thanks Jonathan,

what if I want to display the top average of a product?

So, calculating the average of each product of each person and just displaying the top average in the end?

Thanks,

Alex