Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
Hi,
Can you please send your example calculation in excel with example data.
regards