Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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