rank for previous YTD

[YanMin]

Hi, 

Is there anyway that I can get rank based on the previous YTD? I try this code but doesn't show me correctly.

num(rank(sum({<TRANSACTION_FLAG={'CAR_REGN'},Var_Date ={">=$(vPrevYearStartCarRegn) <=$(vPrevYrSameMonthCarRegn)"},FCST_VERSION=>}Quantity)))

where vPrevYearStartCarRegn= first day of previous year

vPrevYrSameMonthCarRegn = current day of previous year.

but didnt give me correct rank.

Can anyone assist thanks in advanced.