Hi,
I have the data in below format and I want to get the net values against each Purchase Order number and the line item
Can someone please help?
Thanks,
Solved! Go to Solution.
Hi @Pushpendra_1 ,
do you expect as the "net value" the aggregation of the different lines per purchasing document/line item? You should use a SUMMARIZE tool and set "Purchasing document" and "Item" to "GROUP BY" and "Quantity" and "Amount in doc.curr" to "SUM".
Does this help?
Best regards
Roland
Thank you so much Roland. That really helped.