Hi Lei Chen,
Thanks for reply. It works but I am wondering if there is any possibly easier solutions. so for the moment I will keep the discussion open and then we see.
that's really good. Could you explain what does that "index2:1" does ?
Place the index2 field onto Columns, and the logic will be more clear.
Since max date is required,
- Year and Month is descend sorted.
- index2 table calculation is computing using order date.
Thus index of the last Year/Month is 1, then 2,3,4....
Filter index2 to 1, and only the last Year/Month is shown.