Summarize data tool problem

[Jkiddin10]

Hi i have this data set that's not working correctly because all of the summations by quarter/company comes out to be equal every quarter after i export to excel and create a pivot table which makes no sense because how is every quarter the same amount of values? I don't know what i did wrong in between when i changed the values to Int 64. Can you somehow figure out what went wrong when summing up the values?

[binuacs · Accepted solution]

@Jkiddin10 Try changing the Dynamic Input tool configuration like below and try

Spoiler

[DawnDuong]

hi @Jkiddin10 

Actually the summary tool works just fine. the issue is with the way the Dynamic Input is set up. Refer to the ultimate guide here: https://community.alteryx.com/t5/Engine-Works/The-Ultimate-Alteryx-Holiday-gift-of-2015-Read-ALL-Exc...

Also shared here is one possible way to do that with batch macro. 

Hope this helps.

Dawn.