Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Dimension Limits - Show values that accumulate to X%. Substitute the value for your variable.
Dear Rupert,
It does not works,
However, done some trick like ->
Although thanks for looking into.
Regards,
Girish.
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))
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))