Spacing between grouped accounts

[Jenina]

Hi All,

How can I put space after grouped accounts and put "Total" on the total amount row. See below sample. Thank you.

Before:
Account	Side	CCY	Amount
balance1	debit	AUD	100
balance1	credit	AUD	-200
			-100
balance2	credit	USD	-300
			-300
balance3	debit	EUR	500
balance3	credit	EUR	-100
			400
After:
Account	Side	CCY	Amount
balance1	debit	AUD	100
balance1	credit	AUD	-200
Total		AUD	-100
balance2	credit	USD	-300
Total		USD	-300
balance3	debit	EUR	500
balance3	credit	EUR	-100
Total		EUR	400

[PuffinPanic]

Hi Jenina,

I used the solution found in this thread: Solved: Adding an Empty Row Between Data - Alteryx Community which worked perfectly for me. 

Use 'Total' in your first field as the identifier for where the new row needs to go.

I hope this helps.

Nicola

[EKasminsky]

There's probably a smaller workflow you could use but this works! I created this based on the solution @PuffinPanic provided.

[flying008]

Hi, @Jenina 

FYI.

Spoiler

IIF([RowCount] = 2, Null(), IIF([RowCount] = 1 && IsEmpty([_CurrentField_]), 'Total', [_CurrentField_]))

Account	Side	CCY	Amount	RowCount
balance1	debit	AUD	100	1
balance1	credit	AUD	-200	1
Total			-100	1
balance2	credit	USD	-300	1
Total			-300	1
balance3	debit	EUR	500	1
balance3	credit	EUR	-100	1
Total			400	1