Customer segmentation

[Former Member]

I want to create a customer segmentation report on FI-AR data. I want to drill down by Company Code in the rows and view the 0DEB_CRE_LC amount.

In the columns I want to create a structure which contains the 0DEB_CRE_LC value for the top 10 customers per company code, then the value for 10% to 20% customers, and so on.

0COMP_CODE____TOP10%____10TO20%____BOTTOM10%

1000_____________£1,091______£297________£105

2000_____________£23,546_____£15,021_____£3,030

The idea is that I can show for each company code how much of the total accounts receivable balance is due from the top 10% of customers, and cascading down to the bottom 10% of customers.

Any ideas how to create this?

Edited by: Khaled McGonnell on Jan 25, 2010 5:50 PM

I have defined a calculated key figure which is 0DEB_CRE_LC and have calculated single values as Olympic Rank Number. I want to use the rank number in another key figure. However, the rank number isn't used, the actual value is used. How can I make it so that the actual rank number is used?

[Former Member]

Use of Virtual Key Figures in InfoProvider enables use of rank in other formulae.

[Former Member]

Hi Khaled,

Can you please share the logic you applied to create the virtual keyfigure for ranking, we have the same scenario where user

wanna have a field for ranking for sale .

Thanks

Kumar