Hi, Yun

Please try this calculaiton

[Group] = {Fixed:Max(if [Date] = {Fixed :max([Date])} then [Group] end)}

This will give you the flag of the rows you expected.

and for your date range filter, please right click and select add to context.

Hope this helps

ZZ

Yes, Yun. and if you add date as filter, make sure you right click the date filter and select add it to context.

ZZ

no worries,

ZZ