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