count top 10% customers

[xtrimf]

Hi,

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

Itried to use

count({$<Customer= P({<Sales ={">=$(=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....

[Anonymous]

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

)

[sunny_talwar]

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.

[xtrimf]

Hi,

I'm not including boundry values.

and anyways the diff is way to high.

here is some data:

Item	Quantity	% Acc
1158517	33	3.5%
1158524	20	5.6%
4923099	15	7.2%
46	14	8.8%
1158722	13	10.2%
91	13	11.6%
188355	13	12.9%
964775	12	14.2%
22	12	15.5%
7296073230663	12	16.8%
1158531	11	18.0%
922591	11	19.2%
2331322	11	20.3%
688732	10	21.4%
1692	9	22.3%
480	9	23.3%
1715	8	24.1%
262239	7	24.8%
8909877	7	25.5%
121	7	26.2%
1158661	6	26.9%
1158500	6	27.5%
187709	6	28.1%
1158579	6	28.7%
1158548	6	29.3%
176	6	29.9%
964300	5	30.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!

[xtrimf]

Hi,

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

[xtrimf]

anyone?

[maxgro · Accepted solution]

maybe here

http://www.naturalsynergies.com/q-tip-11-so-how-many-customers-make-up-most-of-your-sales/

[xtrimf]

maxgro‌ that was it!! tnx

[maxgro]

thanks to Oleg troyansky‌