How to show maximum value of the dimension aggregated over other dimension
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.
Order Value (ex. VAT)
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.