Limit data using expression based on latest week

[Mohd faizal Adris]

I have calculated column [Week] andwant to limitdata by showing the latest week as below expression;

[Week]= Max(([Week])) AND [Category]="ABC" AND [Department]="123"

After applying the expression, it returned (empty) as an output instead of sum total time.

Anyone, can advise me on this Thanks.

[Shashank Gurnalkar]

It looks like you do not have any records/rows which are intersected by the above three conditions and that's the reason for empty data. You can check this by simply using [Week]=Max([Week]) and you would get some results.