Announcements
cancel
Showing results for
Did you mean:
Creator

## count top 10% customers

Hi,

I need to display in a textbox how many customers are in the top 10%...

Itried to use

 count({\$=\$(=Fractile(Total Sales,0.9))"}>} Customer)>} DISTINCT Customer)

but didn't get the same results as I get when using Dimension Limitation in a chart object....

1 Solution

Accepted Solutions
MVP
8 Replies
Anonymous
Not applicable

May be try this ?

Other functions can be used quite effectively within an AGGR like this. For example:

=if(

Aggr(Rank(Sum(Sales)), customer)<=10,

Country

)

MVP

Are you including boundary values in the dimension limits? AFAIK the result of dimension limits and fractile doesn't always match perfectly. If you can share a sample, we might be able to propose an alternative.

Creator
Author

Hi,

I'm not including boundry values.

and anyways the diff is way to high.

here is some data:

Item Quantity % Acc
1158517333.5%
1158524205.6%
4923099157.2%
46148.8%
11587221310.2%
911311.6%
1883551312.9%
9647751214.2%
221215.5%
72960732306631216.8%
11585311118.0%
9225911119.2%
23313221120.3%
6887321021.4%
1692922.3%
480923.3%
1715824.1%
262239724.8%
8909877725.5%
121726.2%
1158661626.9%
1158500627.5%
187709628.1%
1158579628.7%
1158548629.3%
176629.9%
964300530.5%

When using Dimension limit "show only values that accumulate to" , lets say %10, then it will leave 4 first rows.

I need to achieve the result "4" with a seperate calc , best also I f I could get these Items with concat...

tnx!

Creator
Author

Hi,

I am talking about accumulative percentage - it cannot be achieve the way you suggested, please look below for an example

Creator
Author

anyone?

MVP
Creator
Author

maxgro‌ that was it!! tnx

MVP

thanks to Oleg troyansky

Community Browser