Column sub and grand totals

[Sophie95]

Hi,

I had used what I thought was an simple and quick way to add totals and subtotals without creating a huge workflow from that but I ended up with question below. If anyone can help me.

1. move my grand total to the bottom of the table
2. remove all blank rows
3. how can I get my region totals and WW grand total to line up with the entity  list. without creating separate 2 columns region total  and WW grand total.

here is an example of what  my results should be:

Region Co     Co.Code        Co.Name         Payable Balance

Americas       XXX                XXX                   100

Americas       XXX                XXX                   300

Americas Region Total                                   400

Europe           XXX               XXX                   500

Europe           XXX               XXX                   250

Europe Region Total                                      750

WW Grand Total                                          1150

I attached my workflow

[benakesh]

Hi @Sophie95 ,

Can you include sample data   ? 

[Sophie95]

Sample data

[Sophie95]

Hi @benakesh 

I have added the data file.

Thank you!

[benakesh · Accepted solution]

Hi @Sophie95 ,

With these  minor changes the result matches the expected format. 

Filter :  exclude  blank/null  rows 

Union:  set specific order  for grand total row union 

Summary col : keep  summary column name same to align with other summary cols

[Sophie95]

@benakesh  Very helpful, thank you so much, Alteryx is still new to me.