Percentile Calculation

[#1]

Hello,

I need to calculate the percentile of a customer sales against the other customers sales.

I don't know the formula or function that let me do it. Could anybody help me?

Thanks in advance.

[swuehl]

I assume you have a chart with dimension Customer, and that you want to compare his sales to the total sales (all customers).

=sum(SalesField) / sum( TOTAL SalesField)

[replace SalesField with the appropriate field name]

If you want, you can set the number representation to percentage in numbers tab.

[Anonymous]

Try with:

sum({<Costumer={'CostumerThatYouWant'}>}SalesField) / sum(total sales field)

That compares a specific costumer against the rest of costumers, that is what I understood. And how said swuehl, you can set in numbers tab.

Regards.

[Anonymous]

Hi,

   Can you please send your example calculation in excel with example data.

regards