Append a row that calculates total of category in Google Sheet Node

[Ernest_Yao]

Describe the problem/error/question

How do create a workflow to organize the invoice description by alphabet and for each category, append a row to calculate the total amount? Examples below

This ^ to below v

What is the error message (if any)?

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)
I do not have a workflow yet. 

Share the output returned by the last node

Information on your n8n setup

• n8n version: 1.107.4
• Database (default: SQLite): SQLite
• n8n EXECUTIONS_PROCESS setting (default: own, main): main
• Running n8n via (Docker, npm, n8n cloud, desktop app): desktop app
• Operating system: Windows 11

[jabbson]

By which logic does Order 250220 becomes Training?

[Ernest_Yao]

lets ignore the order 250220 and order 250263, they are anomalies. Is there a way to append a row with calculated total?

[Ernest_Yao]

I figured out a way to solve this problem, so I do not know if it is the most efficient. I ended up coding in the code node to do it all.

[jabbson]

Sure, without the code node it would look like this:

Input:

Output: