Average, best in class metrics

[#1]

Hello there,

not able to find answer to my question in existing forums in a reasonable time here's what I'd like to get some help on:

Have a list of say customers with their sales. There's Sales Amount by customer, next to it is Average Sales benchmark of all listed customers, Avg Potential all OK.

I struggle when trying to display Best-In-Class performance i.e. Top Sales (highest sales per selection - the top performing customer) and Top Potential (as a difference between Top value and actual sales per customer).

	Sales Amount	Average Sales	Avg Potential	Top Sales	Top Potential
Customer 1	70	40	-30	70	0
Customer 2	40	40	0	70	30
Customer 3	10	40	30	70	60
	120

Any ideas?

Cheers

Pavol

[#2 · Accepted solution]

Please go through the application which i have posted....

[#3]

Thanks for posting it, it does exactly cover the question, only if my SalesAmount was not already a complex formula but single field with values! The Max(Total ...) returns all Null() values. Any ideas how to deal with calculated fields for this case?