Cumulative costs based on hierarchy

Hi Guys,

Can someone please help me with the logic of how I can create a workflow that basically creates a accumulative cost based on how products have moved from Their respective shop types. Starting from Manufacturing to Distributor and then to the shop.

The Hierarchy column shows how the products move from one shop type to another. Please note I used an example and in the full data set there are more products. The Hierarchy is something I just created to show how the products move and is not in the dataset. A for Manufacturing, B for Distributor and C for Shop.

I basically need to create a workflow that will group the send and receive thus creating a running total like below.

The red text is the returns of an item (B_A).

Thanks guys any advice will be greatly appreciated.

Workflow

Tips and Tricks

Macros

Accepted answers

DeanWest

Hopefully, this helps! I transposed the data and then used a Tile Tool to group the "Send" and "Rec" values. After that, I used a Multi-Row Formula Tool to calculate the running total.

If you need any more assistance, please feel free to reply to my comment.

Note: You can use the RecordID that is deselected in the last select tool to keep track of the original product order and record count of the incoming dataset. (see snippets below)

Grouped by Group_Number:

Sorted by Group ID

Grouped by RecordID:

Sorted by Original RecordID

Please mark this answer if it was an appropriate solution! 🙂

Group_Running-Total_solution-DeanWest.yxmd

All comments

DeanWest

Hopefully, this helps! I transposed the data and then used a Tile Tool to group the "Send" and "Rec" values. After that, I used a Multi-Row Formula Tool to calculate the running total.

If you need any more assistance, please feel free to reply to my comment.

Note: You can use the RecordID that is deselected in the last select tool to keep track of the original product order and record count of the incoming dataset. (see snippets below)