Total amount per group of data

Hi All,

Is there an easier way to show the total amount per group of data just below it? And anything below $50/($50) will be commented. The initial way I can think of is via join/union but can't get the exact output. I have attached the sample input and desired output.

Thank you all.

Book5.xlsx

Datasets

Transformation

Accepted answers

binu_acs

@Jenina updated workflow attached

Sub_Total_07082025.yxzp

All comments

binu_acs

@Jenina just want to confirm in your attached file is the input and the output are in correct order or you want the opposite way, I mean the output tab has the actual input data and input has the output data?

binu_acs

@Jenina one way of doing this

Sub_Total_07082025.yxmd

Jenina

@binu_acs hello, the Input tab has the actual input data , output tab is the outcome I want. Thanks

binu_acs

@Jenina, in that case, if you exclude the Match Id NULL value, you will get the output. Or am I missing something?

Jenina

@binu_acs Sorry, I'm getting parse errors. Looks like it's because the original amounts in my raw file are all absolute, can you please update that? Credit is *-1, debit*1.

Thanks

Jenina

@binu_acs Hi again! Apologies! I swapped the input and output my bad. The input is all -1 match ID. The output is the one that should generate the subtotal. Apologies!

Book5.xlsx

binu_acs

@Jenina updated workflow attached

Sub_Total_07082025.yxzp

Jenina

Thank you @binu_acs

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703