Sum grouped fields Dynamically

[BautistaC888]

Hello,

I need to sum numeric fields grouped by an ID field. I used the summarize tool but i need to know if there is a way to sum any new field that gets added to the database dinamically (without manually updating the tool).

Thank you.

[Deano478]

You could use a combination of Transpose and Cross Tab tools to add some level of dynamic to what you trying to achieve. Here is a reference for help purposes: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/dynamic-summarize/td-p/482985 

[binuacs · Accepted solution]

@BautistaC888 As @Deano478 mentioned this can be achieved with the help of the transpose and Cross tab tool