Summarize Tool - New Columns month over month needing to be summarized

edavies

Hello, I'm currently using the Summarize tool to come up with allocations.  However, I expect there to be additional columns to be added in the future that will need to be summarized to capture new data.  Since the summarize tool only summarizes on the current selected data, I expect my current workflow won't capture those new columns.  Is there a way to implement something in my workflow that will capture these additional columns/criteria without going into my workflow each time and manually selecting the new data I want to summarize?

I hope this makes sense, and appreciate any help!

Prometheus

@edavies In this example, I'm using some dummy data with store revenue. There are two datasets to choose from. I have the 6 months dataset connected, but you can connect the 9 months dataset and run it and see how transposing your data can help you create a more dynamic workflow. If you use the Transpose tool to pivot your data, you will then have all of your values in a single column that you can sum and choose your categorical data to group by. If you can upload some dummy data with the correct fields, I can create a more specific solution for you. 

6 Months:

9 Months:

Dynamic Add.yxmd