How to add a new row in Alteryx?Help.

[Sriram_ts03]

Hello All -

I would like to get help in tweaking my Alteryx workflow to get the desired result. After using various tools i have arrived the result using summarize. However i would need to add a row and zero out the amount column using an offset account at Department level.

Thanks & Regards,

Sriram TS

[IraWatt]

Hey @Sriram_ts03,

Would you be able to give the example data set rather then an image?

[CarliE]

Hi @Sriram_ts03 

Attached is a workbook!

Please mark it as a solution if it helped solve your issue.

Thanks

[binuacs]

@Sriram_ts03 One way of doing this

[Emmanuel_G]

@Sriram_ts03 

Find in attachement the way of doing this.

Let me know if there is any issue and please do not hesitate to mark this answer as solution if it worked.

[Sriram_ts03]

I want to add Formula that if Department 1200 is in negative - add a row with department as 1200 and account as offset and with positive amount to zero out the whole .