Bifurcating No of orders in buckets in query

28 Views

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