grouping total

[nirvapatel1998]

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 

[acarter881]

Hello, @nirvapatel1998.

Can you provide a sample output for one or more of the IDs? I'm not sure what transformations are required.

[steven_king · Accepted solution]

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.

[nirvapatel1998]

Thank you so much! It helped me find solution