cancel
Showing results for 
Search instead for 
Did you mean: 

Bifurcating No of orders in buckets in query

Former Member
0 Kudos
41

Hi,

i have a requirement for display the No. of Orders region wise and the also to bifurcate them in the buckets like... 0-100, 101-200... for its amount value per order in following way.

i am able to get the total no of orders.. for each region but nt able to bifurcate them


Value	Mumbai	Pune	Goa	Delhi	
0-100					
101-200	1		
201-300					
301-400		1	
401-500 2			
501-600					
601-700	1		
701-800		1	
801-900				
901-1000					

following is the sample data i have in ODS


Invoice No	Order No Region	Amount
8000007	1000001	Mumbai	500
8000008	1000002	Pune	800
8000009	1000003	Goa	700
8000007	1000004	Mumbai	450
8000008	1000005	Pune	100
8000009	1000006	Goa	330

Thanks..

Sonal...

Edited by: Sonal Patel on May 27, 2009 2:39 PM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello,

Drag and drop sales order KF into the rows.Hide the same.

Then create a CKF with descr 0-100.

Give condition('No of orders' between 0 and 100 * ''No of orders' +'No of orders' not between 0 and 100 * ' ' )

Similarly create for remaining ranges you need.

then finally in the column , place the region

Try if this works out.

neelesh_jain3
Contributor
0 Kudos

1. Drag and Drop Region into Columns.

From here on, In Rows

2. Create a CKF with description "Logic 0-100", amount <= 100 * amount >=0.

3. Create a CKF with description "Logic 100-200", amount >100 * amount <=200

4. Similarly create for all the remaining values... 900-1000.

5. Make all these CKF as Invisible.

6. Create a CKF with description "0-100" and go to edit of CKF and go to tan Aggregation and select Exception Aggregation as "Count all the occurences which are not zero, error..." and Ref. Charectreistic as "Invoice No".

Cheers,

Neel.

Answers (0)