Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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