Rangesum Above Dimension Problem

[alucard_ae86]

Hello Experts,

I have calculated stock of some materials  by using the following expression 

RangeSum(Above(
Sum({$<MVMNT={'000','001','004','005','006','010'},DATE={"<$(vDateTo)"}>}STOCK), 0, RowNo()))
-
RangeSum(Above(
Sum({$<MVMNT={'100','101','104','105','106','110'},DATE={"<$(vDateTo)"}>}STOCK), 0, RowNo()))

so i display by date using the expression 

=if( DATE>= $(vDateFrom) and DATE<= $(vDateTo) , Date(DATE,'DD/MM/YYYY'),Date($(vDateFrom),'DD/MM/YYYY') )

 I want to calculate the change of stock by Date comparing with 1 year prior but when i use this expression I have to display all rows to get the right results but i want only to display a range of dates

RangeSum(Above(
Sum({$<MVMNT={'000','001','004','005','006','010'},DATE={"<$(vDateTo)"}>}STOCK), 365, RowNo()))
-
RangeSum(Above(
Sum({$<MVMNT={'100','101','104','105','106','110'},DATE={"<$(vDateTo)"}>}STOCK), 365, RowNo()))

Thanks in Advance

Regards

[sunny_talwar]

Would you be able to share a sample to show what you have so far?