How to show maximum value of the dimension aggregated over other dimension

[#1]

Hello, I have a straight table with 6 dimensions, no expressions – I do not need expressions because all the data I need to show is already in the model.

PO Number	Doc Type	Delivery Date	Order Value (ex. VAT)	Outstanding Value	Delay
4500000001	Standard PO	09/06/2015	100	100	22
4500000002	Standard PO	29/04/2015	200	200	63
4500000003	Standard PO	22/06/2015	300	300	9
4500000004	Standard PO	26/03/2015	400	400	97
4500000005	Standard PO	05/05/2015	500	500	57
4500000005	Standard PO	15/05/2015	500	500	47

Out of those dimensions all but two come from one table (POs). Only Delivery Date and Delay comes from different table (PO items). PO 4500000005 have two dates and delays in the straight table because for this PO exists two items with different dates.

Now, what I want to do is to show only one row (with the later date) for one PO in this table. So PO 4500000005 should only have one line with 15/05/2015 delivery date and 47 Delay Days.

Could you please advise how this can be achieved? I am attaching sample application as well.

Thank you,
Mat

[Anonymous]

with a Workaround i got it

create an Expression maxstring(Delivery date) but hide them (prersentation)

define Dimension Limit for delivery date and don't Show others

look at my solution !

[Anonymous]

Try this as an expression

=if(max(TOTAL <[PO Number]> [Delivery Date])=[Delivery Date], Delay)