Calculate Max Date

Dear Gurus,

I have 0CALDAY, 0MOVETYPE and 0MATERIAL in different dimensions in a Cube. I want to display in my query Max of 0CALDAY where 0MOVETYPE = ('101', '103', '105') for each Material. I am not sure how I can achieve this in BEx.

Please advise.

Appreciate all the help.

Thanks.

Regards,

bw_newbie