In Chart - Display Customers with Top n Percentage of Total Order Qty

[girish_talele]

Dear Experts,

We have a Data in Chart as given below,

Based on order qty, we can display (only) Top n numbers of customers using variable (say nTop).

Now we want to display Customers based on top "XX" percentage where percentage will be entered using variable.

Customer	OrderQty
Cust-1	100
Cust-2	75
Cust-3	50
Cust-4	25
Cust-5	15
Total	265

Please suggest whether we can achieve the same.

Regards,

Girish.

[Roop]

Dimension Limits - Show values that accumulate to X%. Substitute the value for your variable.

[girish_talele]

Dear Rupert,

It does not works,

However, done some trick like ->

Although thanks for looking into.

Regards,

Girish.

[MK_QSL]

try

IF(SUM(OrderQty)/SUM(TOTAL OrderQty)>=nTopPercentage,SUM(OrderQty)/SUM(TOTAL OrderQty))

or

IF(SUM(OrderQty)/SUM(TOTAL {1}OrderQty)>=nTopPercentage,SUM(OrderQty)/SUM(TOTAL {1}OrderQty))

[its_anandrjs]

You are using Top n Correctly

For top "XX" percentage you can use

If(sum(OrderQty) * 100 / Sum( TOTAL OrderQty) >= nTopPercentage ,sum(OrderQty) * 100 / Sum( TOTAL OrderQty))