Hi,
Can someone please guide me the best way to get the below output:
What I need to do:
- Group by ID
- To find Total, I need to see if quantity is different within the same group pick the different quantity(unique within same group) price and total up that, if the quantity is same then use the same price for total
Thank you in advance
Solved! Go to Solution.
Hello, @nirvapatel1998.
Can you provide a sample output for one or more of the IDs? I'm not sure what transformations are required.
Hi @nirvapatel1998, please see if this works for your use case. First, use a Summarize Tool to group by ID, Qty and Price. Then use another Summarize Tool to group by ID and sum Price (renamed to Total). Finally, join the Total field back into your original dataset. Screenshot below.
Thank you so much! It helped me find solution