ADD A TEXT

[draghava]

In a excel we will add a Row " total" when the total is done for a column . In a attached example  text "TOTAL"  was typed in a  " C23" . How to do this in alteryx . please help 

[Ladarthure · Accepted solution]

Hi,

one solution to do this kind of things is to use an union with a summarize tool, it creates a "total line". another solution would be to use the Crew macro pack with their add totals macro.

[draghava]

Thanks . It works but one issue your formula works only if one blank row . But what if two or three blank and i need only in one particular row. 

[Ladarthure]

You could get the last row with a sample tool, and then union it, or just modify it before unioning the data.