Calculating sub-totals

Question

Hi all, need help in calculating subtotals. I used some of the solutions already provided, however, the issue is that my data is not fixed.So, how can I achieve the subtotals (output file) with multiple changing records that does not have any unique identifier. Please help.

dummy output.xlsx

dummy input.xlsx

Jean-Balteryx · Accepted Answer

Hi @SCK ,

I attached a sample workflow doing what you want.

Tell me if you need more details !

Cheers,

Jean-Baptiste

atcodedog05 · Accepted Answer

Hi @SCK

Here is a workflow for the task.

Output

Hope this helps : )

If this helps please mark the post as solution

atcodedog05 · Accepted Answer

Thank you @Qiu

vizAlter · Accepted Answer

Hi @SCK — Hope this also helps:

Please mark it "Solved" or "Solved" with a Like if it resolved your query. This will help other users find the same answer/resolution.  Thank you.