Calculate Max Date

[Former Member]

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

[Former Member]

Can you add 0Movetype to your characteristic restrictions and restrict it to the values (100, 103 and 105)

In the display properties for 0Calday select Sort according to Descending .

Would that work?