Add Total Row

[Kureel]

Can someone please help me when adding a total row. Every time I seem to add a row it gets pushed off to the side of the data and not incorporated in the data.

[apathetichell]

you are using a Union tool with a config by name - try a config by position - or a manually configure fields.

[Kureel]

it shifts everything over to the left one too many columns

[Kureel]

See attached

[binu_acs]

@Kureel can you upload the input excel file?

[apathetichell · Accepted solution]

two ways: 1)

add grand total. use a select tool to move it to the first field. configure by position.

2) manually configure fields