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.
