Calculation Line

AlteryxLearner23

Hi,

I have the attached workflow with a sum calculation on the bottom.

I'm trying to enhance this workflow so there is a sum for every two lines.

At the moment we have this

Line 1 Expense         200
Line 1 Payments       -100
Line 2 Expense         300
Line 2 Payments       -50

Calculation                350

I want to change it to look like this

Line 1 Expense         200
Line 1 Payments       -100
Calculation                100
Line 2 Expense         300

Line 2 Payments        -50
Calculation                 250

Every set of data has one line for 'Expense' and one for 'Payments'.

Hope this makes sense.

Calculation Script.xlsx

ed_hayter

I went with a summarize tool to group by the ID to create the subtotal - then replicated the column structure so that we can union (stack) the sub-totals back into the original table. Part of that was creating a Forecast Type column for the Sub-totals all with the value =  "sub-totals" so that they can be filtered out when we want to.

Subtotals.yxzp