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?