Skip to Content
0

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

Sep 18, 2017 at 03:18 AM

25

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers