Multiple Running Totals

[NRD]

Good Morning,

I am trying to create the below subset within Alteryx but cannot figure out how. I have the 5 header fields complete but I cannot figure out how to add multiple "Grand Total" fields at the bottom of the data set. Please help!

Identifier 1       Tax Amount               Identifier 2      Tax Amount 2         Comparison

A                     10.00                           A                     -15.00                        (-5.00)

B                     20.00                           B                    - 20.00                         0.00

C                     30.00                           C                    - 30.00                         0.00

D                      40.00                          D                     -40.00                          0.00

Grand Total 1     100.00                     Grand Total 2 105.00

[Jonathan-Sherman]

Hi @NRD,

This could be achieved by summarising and unioning back:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[NRD]

@Jonathan-Sherman 

Using your solution I am getting the below result:

[Jonathan-Sherman]

Hi @NRD,

It doesn't look as though you've unioned it back to the original data set?

If this solves your issue please mark the answer as correct, if not let me know! 

Regards,

Jonathan

[NRD]

@Jonathan-Sherman I have unioned it back to the data set thats just how it looks. Those fields are now to the right of my live data.

[Jonathan-Sherman · Accepted solution]

Your grand total columns (i called them "Identifier 1", "Identifier 2", "Tax Amount" and "Tax Amount 2") need to have the same column headers as the column you want the value to sit under.

You're grand total values (and labels) are in different columns because the column headers are not the same.

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

[AbhilashR]

An alternate way to get your column additions could be to use a CrossTab tool. It depends on how your data is structured so I thought I'll throw it out there to introduce another way to add.

[NRD]

@Jonathan-Sherman @AbhilashR  Thank you both!