Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Total Sum of Entire Input Data

mlg01951
6 - Meteoroid

Trying to find a way to properly use the summarization tool to gather a sum of the entire data set collectively (for reconciliation purposes to the input data).

2 REPLIES 2
binuacs
20 - Arcturus

@mlg01951 one way of dong this is to Transpose your data and take the sum of the amounts using the summarize tool

mihaicom20
8 - Asteroid

First proposal is to use Summarize tool for each Col and after to Summaraze the totals 

Second to use the Add Totals from Crew Macros  https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CReW-Macro-Support/ta-p/465740

 

Labels