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 |
