Hi
I am trying to create a macro where it can take any numeric data type field. I then would have two summarize tools connected to this, one group by the values and a string and then one that would display total sum of the value, then I want to union so that the total will show at the bottom of the grouped value. I want this macro to respond to any input that has numeric fields in it, because I work with many different files and don't want to create the same tool many times.
Is there a way of doing that?
Thanks
Hi @BillyL14 ,
I recommend the DYNAMIC SELECT tool, which allows you to select columns with specific data types, such as numeric columns:
Let me know how you proceed and if you need help with the remaining steps.
Best regards
Phil
thanks a lot to both, I am still working on it