ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

SUM only the rows below

BautistaC888
8 - Asteroid

Input:

BautistaCaparelli_0-1612289513205.png

Expected output:

BautistaCaparelli_0-1612290393459.png

 

I want to SUM the Totals below the current one. I'm a new user and i'm stuck with the multi-row formula.
Thank you.

 

2 REPLIES 2
Emil_Kos
17 - Castor
17 - Castor

Hi @BautistaC888,


I have prepared a workflow for you:

 

Emil_Kos_0-1612290998335.png

This is the output:

 

Emil_Kos_1-1612291005871.png

 

echuong1
Alteryx Alumni (Retired)

You can actually take advantage of the running total for this! You'll just need to reverse the order of your data.

 

I started by adding a record ID, so I'd know the order of the data. I used a sort to reverse the order. I then used a Running total to calculate the subtotal, and then another sort to put my data back in the original order. A select renamed the column to subtotal.

echuong1_0-1612291514013.png

 

Labels
Top Solution Authors