on 04-05-2006 3:23 PM
Hi
We have Billing Cube. in which one of the characteristic is a customer and we have key figure called billed amount.
Their is requirement to show report in following manner.
Billing done Result
0 to $10000 12
$10000 to $40000 5
$40000 and %100000 12
29
Bucket stands for the sum of billing done to various customer in the given period
Thanks for the help in advance
Hi,
If you are able to modifiy your InfoCube then introduce a New KF called "Customer Count", the properties of the KF should be set to "Exception Aggregat. = Counter" and Agg. reference char = Customer Char.
Now you can create CKF based on revenue buckets.
This is helpful espically in cases if the customer gets billed more than once but you want him to be counted only once in a particular period.
Hope that this helps.
Thanks
Srini
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
This would work fine, i want to know based on t he billing amount. if i want to know based on the total billing done in a given period.
for example MR a i have done a billing of 100, 4000 , 9000 in a given period
i would like to show him in the 10000 to 40000 category and he has to be counted only once. he should not be counted more than once.
Hi,
If i have understoodd u r requirement correctly,try this:
Create a 3Fomulas say
Formula1 = (billing amt >= 0) AND (Billing amt <= 10000)
Formula2 = (billing amt > 10000) AND (Billing amt <= 40000)
Formula3 = (billing amt > 40000) AND (Billing amt <= 100000)
and 3 more formulas
Count1 = COUNT ( 'Formula1' )
Count1 = COUNT ( 'Formula2' )
Count1 = COUNT ( 'Formula3' )
'COUNT' function is available under 'Data Functions'.
>=,<,....etc are under Boolean operators.
Set 'Calculate result as' summation for all COUNT1, COUNT2,and COUNT3.
So you in Overall Result row,you will see no of customers billing done between 0 to $10000 (from formula1).....etc...
You can Hide Formula1,formula2,and Formula3. And Change Descriptions of Count1,Count2,and Count3 as required.
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In addition to that,
create one more formula say 'count4' to calculate total customers:
Count4 = (billing amt <= 0 ) OR ( billing amt>= 0 )
and set Calculate result as...Summation..
In Overall result row,You can see total no of customers...and You can always cross check with individual no of customers..i.e. Count1count2count3 = count4.
Here I assume All biling amounts falls in the range 0 to 100000.
Then only Count1count2count3 = count4.
Thanks
Srikanth,
Ways to do this would be :
1. Define your restrictions and declare the count in the formula editor to find out the count of values.
2. have a separate KF with values of 1,2 3,for each of the buckets and have a CKF which counts on the new KF but that would be a more tedious process.
Arun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.