Multi-row tool help needed

[Sandeep077]

Hi,

I want to create a separate column which will show the highest product amount grouped by Transcation ID

(I've already selected in yellow highlight- which will show as output in next column)

Kindly assist.

[atcodedog05]

Hi @Sandeep077 

Here is how you can do it.

1. Use summarize tool after the multi-row formula tool to get max Amt.

2. Use join tool with Transaction_ID as key to join the max Amt with the data.

Hope this helps : )

[allwynthomas24]

Hey @Sandeep077,

Is this what you looking for ?

Spoiler

Didn't understand the aim behind taking running total and then finding the maximum amount out it. 

Earlier I had worked on such data in my workplace and the aim was to know the maximum transaction amount spent on a single product by a customer to understand their spending capacity. Anyways I have also included this in the attached workflow. If its of no use for you then you can delete that part.

Thanks & Regards.