We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

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

Sum a Range/Series of Rows

knorr
5 - Atom

Hi, 

 

I'm looking to calculate the Sum of each Color across Jan through Mar. My actual dataset includes 30+ columns/data fields so I am looking for a solution that does not involve adding each field in a Multi-Row Formula (i.e. Jan + Feb + Mar... etc).

 

 JanFebMar
Red11127.5
Orange1013.019
Yellow14.452
Green821.11

 

Thank you!

5 REPLIES 5
DataNath
17 - Castor

@knorr are you wanting to sum all fields? You can transpose the data, selecting colour as a Key Column. Afterwards, you could use a Summarize tool to then Group by Colour and Sum the values. If you need this sun added to the original data set then you can just use a Join tool, with Colour as the join field.

 

Example attached:

 

DataNath_0-1663706446010.png

Emmanuel_G
13 - Pulsar

@knorr 

 

Find in attachement the way of doing this.

 

Note that even if you have many fields, It is enough that the box Dynamic or Unknown Columns is checked in transpose tool so that all your columns (apart from those which have been taken into account in key columns ) are mapped into data columns and therefore transposed.

 

Please do not hesitate to mark this answer as solution if it helped.

 

Emmanuel_G_0-1663713186028.png             

Emmanuel_G_1-1663713213491.png

 

    

 

 

Qiu
20 - Arcturus
20 - Arcturus

@knorr 
The Cross Tab tool has the additon functions for Mothod of Agrregating values.
We can use the Total Colum in your case.

0921-knorr.PNG

Sarreddy
9 - Comet

My solution.

knorr
5 - Atom

Thank you all! I went with a transpose -> Sum -> Join.

Labels