How to Remove "Sum" in Colum headers of table

[Belletmns]

Hi Team,

Need your help, I'm struggling to remove the "Sum_" in the headers of my table.

I Attached the sample workflow. I would like to have the format "01 January".

Thank you

[mceleavey · Accepted solution]

Hi @Belletmns ,

This is a nice introduction to the Dynamic Rename tool.

You can simply add this tool following your crosstab:

I've attached the workflow. 

Hope this helps.

M.

[Belletmns]

Hi @mceleavey 

Thanks for your help! however, is there a way to put the total on the last row?

[mceleavey]

Hi @Belletmns ,

Yes, you can change the order of the columns in the table tool:

If it is already showing the Total field in last place, move it up one and then back down. That should fix it.

M.

[atcodedog05]

Hi @Belletmns 

It can be easily done by using select tool and moving it to the end.

Edit : why didnt i think about that. Repositioning in Table tool itself.

Good one @mceleavey  🙂

[mceleavey]

You have to have some weaknesses, @atcodedog05 

🙂

[Belletmns]

@mceleavey in the table it is the last row, but when you view/extract it, it is in the 2nd row. I think it's automatically sorted.

[mceleavey · Accepted solution]

Hi @Belletmns ,

Yeah, this is a bit of a thing in that tool.

Click on the Total row, click the up button, then click the down button to put it back into position.

That should work:

M.