Row and column totals in one table

[Saravanan13]

Hello,

I am looking get row total and column total in the same table. Can anyone assist on this.

Input

Employee Name	Type1	Type2	Type3	Type4	Type5	Type6
A	7	0	2	4	1	1
B	3	0	2	2	2	1
C	4	0	3	1	3	1
D	3	2	2	0	2	0
E	2	0	0	2	4	0

Output

Employee Name	Type1	Type2	Type3	Type4	Type5	Type6	Total
A	7	0	2	4	1	1	15
B	3	0	2	2	2	1	10
C	4	0	3	1	3	1	12
D	3	2	2	0	2	0	9
E	2	0	0	2	4	0	8
Total	19	2	9	9	12	3

[dwstada · Accepted solution]

here is a crude workflow for that

 

if your column count can change, then the row total formula needs to be changed to something more dynamic ;)

[MilindG · Accepted solution]

@Saravanan13  one way to do this

[grazitti_sapna · Accepted solution]

Hi @Saravanan13 
Attached workflow helps to get solution of it . Kindly Check
Thanks