cancel
Showing results for 
Search instead for 
Did you mean: 

segmentation based on key figure

Former Member
0 Kudos
50

Hi

Suppose I want to do in BEx certain segmentation of the market. It's going to be based on sale value for each client during last year. I've been given some segments of sale value (e.g. 0-999,1000-9999,10000 and more). What I need is to get number of clients and total sale value for each of these segments.

The problem is that segments are based on KF, not on char and also that assignment to certain segment is based on individual client's sale value, but only total value for each segment should be displayed.

How can I achieve this ?

Best regards

Victor

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

You can get by the help of "Formula variable" and "Boolean operations".

Here you have to define a formula varibales on Sales Document( Iam assumiong the cube holds the information for Sales Orders not at the level of Sales Order item level). i.e Formula variable with attribute (constant) of Sales order.

Define a formula (for column '0-999') which is equal to

( 'Formula variable' < 999 AND 'Formula variable' > 999) * Netsales.

Refer for formula variable creation:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/72f4a790-0201-0010-5b89-a42...

With rgds,

Anil Kumar Sharma .P

Message was edited by: Anil Kumar Sharma