From the attached table snapshot, I have used the field Total Open Order Qty as a measure with the expression
= sum({<[Run Date]={"$(=Max([Run Date]))"}>}[Open Order Qty])
But as you see on the attached, the Total Open Order quantity for the particular sales document is repeating for all other measures related to a single sales document.
Is there a way to merge the Total Open order qty for one sales document field value?
Exact replica of the current table used is attached as a image- please look into this
