Hi How to bring total row as below and how to remove Sum_ Input NameSum_OfflineSum_OnlineTotal 112daf112abcd112xyd112wer112 5510 Output NameOfflineOnlineTotal 112daf112abcd112xyd112wer112Total5510 Total.yxmd

hi, After adjusting the Total row in descending order, this logic getting failed. RecordIDNameOfflineOnlineTotal1 55102Total1123daf1124abcd1125xyd1126wer112 Total (2).yxmd

Total row is missing

shahnawaz_khan

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

Total.yxmd

Help

Accepted answers

All comments

binu_acs

@shahnawaz_khan using dynamic rename tool

Total.yxmd

shahnawaz_khan

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

Screenshot 2025-02-14 174633.png

binu_acs

@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

Total.yxmd

flying008

Hi, @shahnawaz_khan

FYI.

录制_2025_02_17_10_15_48_127.gif

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

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.

binu_acs

try now

Total.yxmd

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

Total (2).yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335