Help on a set analysis expresion

[guya]

Dear,

I would like to create a chart (pivot or straight) that shows the following:

the %age represented by the top 40 customers against the total customers
The number total of their corresponding orders and the %age against the total orders
and the average price of these orders.

Can any one help me for the expression?

with many thanks,

Guy

[#2]

Hi Guy,

I think that you must use the Top function in your expression.

For example :

sum( Orders) / top( sum( Orders),40)

Hope this helps 😉

Kindly,