Range Sum above based on specific group issue

[#1]

I have requirement to get the values

Month	SalesGroup	#Sales
Jan 2010	SYA	1
Jan 2010	SYE	185
Jan 2010	SYM	562
Feb 2010	SYA	1
Feb 2010	SYE	143
Feb 2010	SYM	571

expected results is Sales Group has to be accumulated to each group SYA for each period -shown values in the #Expected Results Column

Month	SalesGroup	#Sales	# Expected Results
Jan 2010	SYA	1	1
Jan 2010	SYE	185	186
Jan 2010	SYM	562	748
Feb 2010	SYA	1	2
Feb 2010	SYE	143	328
Feb 2010	SYM	571	1133

I tried

rangesum(above(count(distinct Sales),0,RowNo()))

I have option to select SalesGroup in the layout.

Advance Thanks for your help.

[deepakk]

HI,

I hope this application helps you out.