max function in chart is ignoring dimension

[#1]

I have a straight table where i have to show sum over a date range. The starting point of date is fixed (4th highest date) but end point variable. (like 7th or 10th highest date) depending on a field called SIT.

So, I store variable as vSIT = SIT

=sum({<W_Period={">=$(=max(W_Period,$(=vSIT))))<$(=max(W_Period,4))"}>}WS_Qty)

My dimension is Country. If I use the above expression , if  I hard code then it is taking fine but when i pass variable it is taking maximum value of that field ignoring my country dimension. Please advice.

Country	SIT
INDIA	16
INDONESIA	7
JAPAN	6
KOREA	6
MALAYSIA WEST	5
NEW ZEALAND	8
PHILIPPINES	5
TAIWAN	6
THAILAND	6
VIETNAM	7

[sunny_talwar]

Didn't Stefan already help you on this?

Max function as variable in chart ignoring dimension