Row name "Total" is showing as null

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

Total.yxmd

Help

Accepted answers

alexnajm

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!

All comments

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

Total.yxmd

alexnajm

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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703