Forum Discussion
Community ChampionOne Order Date with Multiple Shipment Dates
Community ChampionHi, Anonymous
Thank you for sharing your solution. Upon doing it, I noticed that you did not put the Qty ordered(from the Sales table) in the matrix. The main purpose of doing this is to deduct the Qty Base (Shipment Table) from Qty Base (Sales Table) to get the Outstanding/Open Qty with the dates involved.
Thank you,
Mussaenda
Hi mussaenda ,
You can add another 'qty base' to value fields, rename these fields based their table name.(sale qty, shipment qty)
After these steps, you can add a measure to get diff from two qty and group by current category.
It will display remain qty which you wanted.
Regards,
Xiaoxin Sheng
- mussaenda
Hi Anonymous,
Thank you for suggesting. I tried to add the order qty in the matrix but it is duplicating base on the rows of date. If you will enlighten me on grouping by current category, it will be a big help since I am a newbie. Bear with me.
See photo below, Thank you!
Warm Regards,
Mussaenda
Hi mussaenda,
You can drag this column row fields after order date, then it will display as total amount of shipment qty.(I rename two fields as sole qty and shipment qty)
Regards,
Xiaoxin Sheng
- mussaenda
Hi Anonymous,
Maybe my questions were not clear. Sorry for that. I will post a clearer question. Thank you for answering my question here, you are brilliant.
Mussaenda