Total row is missing

[shahnawaz_khan]

Hi

How to bring total row as below and how to remove Sum_

Input

Name	Sum_Offline	Sum_Online	Total
	1	1	2
daf	1	1	2
abcd	1	1	2
xyd	1	1	2
wer	1	1	2
	5	5	10

Output
Name	Offline	Online	Total
	1	1	2
daf	1	1	2
abcd	1	1	2
xyd	1	1	2
wer	1	1	2
Total	5	5	10

[binuacs]

@shahnawaz_khan using dynamic rename tool

[shahnawaz_khan]

Row total is still "null" can you please share the exact workflow.

 

[binuacs]

@shahnawaz_khan it is the same workflow i shared, if you have null values at the Total add a formula tool and change it to Total

[flying008]

Hi, @shahnawaz_khan 

FYI.

Input				Output
Name	Count	Status		Name	Offline	Online	Total
abcd	2	Offline			1	1	2
abcd	1	Online		abcd	1	1	2
xyd	2	Offline		daf	1	1	2
xyd	2	Online		wer	1	1	2
daf	3	Online		xyd	1	1	2
	3	Online		Total	5	5	10
	1	Offline
daf	1	Offline
wer	1	Online
wer	2	Offline

[shahnawaz_khan]

Hi 

Record 1 is showing Cell Value as "Total" and Record 6 is also showing Cell Value as "Total" in the screen shot which you shared.

[binuacs]

try now

[shahnawaz_khan]

hi, 

After adjusting the Total row in descending order, this logic getting failed.

RecordID	Name	Offline	Online	Total
1		5	5	10
2	Total	1	1	2
3	daf	1	1	2
4	abcd	1	1	2
5	xyd	1	1	2
6	wer	1	1	2