Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
The Community search bar will be undergoing a scheduled upgrade on January 30th between 4:30-6:30a EST. Please utilize your browser's search during this time. Thank you for your patience!

Alteryx Designer Desktop Discussions

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

How to create an aggregate column (Current line till the last line of the table)

tal_il
7 - Meteor

Hi

I have a cash flow serious which I calculate their present value (colum "PMT PV")

I want to sum all the values from the current line till the last line of the table.

(I attached my spreadsheet as an example so you can see the formulas under the column "Liability")

 

Thanks, Tal

3 REPLIES 3
DavidP
17 - Castor
17 - Castor

Would it work if you add a recordID, sort descending order, add running total, and sort ascending order?

DavidP
17 - Castor
17 - Castor

DavidP_0-1587554909594.png

 

tal_il
7 - Meteor

The running tool is new to me

let me check 🙂

Thanks!

Labels
Top Solution Authors