3 Replies Latest reply: Feb 4, 2013 1:47 PM by Khadar basha shaik

# Percentile Calculation

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.

• ###### Re: Percentile Calculation

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.

• ###### Re: Percentile Calculation

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.

• ###### Re: Percentile Calculation

Hi,

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

regards