Getting Sum/Total of Same Column in Table

[JacobGFMR]

Hello,

I've reviewed various discussions, but I am still having trouble getting a table to look like I need with sums/totals of different columns. 

Here is the table I have. 

PROCESS	MANAGER NAME	MANAGER ID	CHARGE	COUNT	AMOUNT
L1	V	A123456	13647	1	-853.93
L1	G	A124578	13647	1	-52.32
L1	C	A986532	13647	2	-45213.9
L2	H	A639096	13647	2	-9763.77
H1	H	A639096	23081	7	-19308.82
UNIDENTIFIED	UNIDENTIFIED	UNIDENTIFIED	13647	4	-4686.27
UNIDENTIFIED	UNIDENTIFIED	UNIDENTIFIED	23081	1	371.37
UNIDENTIFIED	UNIDENTIFIED	UNIDENTIFIED	13647	1	1699.08

How I am wanting to have the table look. 

PROCESS	MANAGER NAME	MANAGER ID	CHARGE	COUNT	AMOUNT
L1	V	A123456	13647	1	-853.93
L1	G	A123789	13647	1	-52.32
L1	C	A986532	13647	2	-45213.9
L2	H	A639096	13647	2	-9763.77
H1	H	A639096	23081	7	-19308.82
UNIDENTIFIED	UNIDENTIFIED	UNIDENTIFIED	13647	4	-4686.27
UNIDENTIFIED	UNIDENTIFIED	UNIDENTIFIED	23081	1	371.37
UNIDENTIFIED	UNIDENTIFIED	UNIDENTIFIED	13647	1	1699.08
				19	-77808.56

Thanks. 

[JosephSerpis · Accepted solution]

Hi @JacobGFMR the attached workflow should produce the output you describe.