Showing results for 
Search instead for 
Did you mean: 

Calculate Max Date

Former Member
0 Kudos

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.




Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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?