This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
You don't even need a multi row tool Just do a Summarize tool, group by Product and get Min(Amount) and Max(amount). then use a formula tool to make a status of "No Change" if the min = max and "Change" if it isn't.
If you need something more complicated like, is the change positive, or how many changes or longest time between changes, then you need the multi row tool.
Hi @amadra , the multi-row tool was my first instinct and I think you could use it to get your intended result. Instead though, I used a summarize tool to find the min and max for each product. If the min equals the max, then there was no change. I attached my version of the workflow.