Skip to Content

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

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


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers