cancel
Showing results for 
Search instead for 
Did you mean: 

top N% and Bottom N% and rest all in the middle

Former Member
0 Kudos

Hi All

We have BW on HANA system. The front end is Design Studio 1.6.

ADSO holds complete data.

Let us consider a KF1 (for example Revenue)

Top : We have to display Top 20% of customers, Bot 20% of customers and Rest of the customers in the middle as shown in the image. It is not just TOP 20 but it is TOP 20%. if there are 144 customers, Then system should consider top 20% of 144 customers which is 28.8. This should be rounded off to nearest upper integer. it is 29 in this case. Hence revenue from 29 customers should be considered as TOP 20%. Bottom Same logic for Bottom 20% . 29 Bottom customers Middle144 - (29+29) = 86. Hence revenue from 86 customers is considered as middle.

Please let me know if there are any pointers in this regard

Thanking you

Suvesh

Accepted Solutions (0)

Answers (0)