Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Didn't Stefan already help you on this?