Row name "Total" is showing as null

[shahnawaz_khan]

Hi all

After creating a summery Row name "Total" is showing as null also column name is appearing as "Sum_" which should be on same column name.

Need help to understand how to get this thing corrected.

Name	Sum_OFFLINE	Sum_ONLINE	Total
VICKY SINGH		1	1
Ajay Kumar	1	1	2
Akshay Wakhare	1	1	2
Lokesh		2	2
Arun Singh	1	3	4
Sandeep Bansode	3	1	4
	6	9	15

[OTrieger]

@shahnawaz_khan 
I'm not sure if I full understand what you would like to achieve, but there are several ways to get Total in the row.
One of them will be with a Formula tool
IF Name = null THEN "Total" ELSE Name ENDIF

[alexnajm]

Then on top of this you can use the Dynamic Rename is remove your “Sum_” prefix! 

[shahnawaz_khan]

in this attached workflow there are bank in 2 rows how to tackle this?

total should come as total and other blank should come as blank.

stage	Online	Offline
a	1	1
b	1	1
c	1	1
	1	1
b	1	1
a	1	1
f	1	1
k	1	1
	8	8

[alexnajm · Accepted solution]

Newer versions of Alteryx will fill this automatically - for no, you could Sample the last row, make your correction via a Formula, and Union it back!