Spacing between grouped accounts

Question

Hi All,

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

Before:   AccountSideCCYAmountbalance1debitAUD100balance1creditAUD-200   -100balance2creditUSD-300   -300balance3debitEUR500balance3creditEUR-100   400        After:   AccountSideCCYAmountbalance1debitAUD100balance1creditAUD-200Total AUD-100    balance2creditUSD-300Total USD-300    balance3debitEUR500balance3creditEUR-100Total EUR400

PuffinPanic · Accepted Answer

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 · Accepted Answer

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

flying008 · Accepted Answer

Hi, @Jenina

FYI.

Spoiler

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

AccountSideCCYAmountRowCountbalance1debitAUD1001balance1creditAUD-2001Total  -1001     balance2creditUSD-3001Total  -3001     balance3debitEUR5001balance3creditEUR-1001Total  4001