Hello, everybody i need help creating an alteryx workflow. I want my workflow to do multiple different things. First i want it to group my dataset by transaction number putting all the data with the same transaction number into a group without combining the rows. I also want to sort these transaction numbers by date in ascending order. After that i need to calculate PL. This is done by taking the debit or credit amount and balancing it with debit the debit or credit amount with the value on the next row. This will result in both of those rows showing 0 for the PL. However if there is a debit or credit entry that doesn't have a following debit or credit to balance it out the PL impact should show as the debit or credit amount for that last row. This PL amount should be the same as the debit or credit amount recorded. It should also store this number in the same row. After this i want to filter the dataset so that my final document only shows the PL values that are higher than 500,000. After finding this number i want it to show all of the corresponding transaction numbers that lead up to that final number. I have attached an example of the dataset with the PL value already calculated that can help to visualize this and create the workflow in alteryx
