Adding total row to Basic Table that is grouping outputs

[Bren_Spill]

Hi All,

I am using the basic table tool output tables grouped by Department. Screen shot below is an example of the data flowing into the Table Tool.

Does anyone know if there's a way to add a total row at the bottom of each table output? So as per the screen shot I would have one table for Administration and another for Entertainment, and I need a total for Jan 2019, Jan 2020, and Variance on both.

Thanks!

[DavidSkaife · Accepted solution]

Hi @Bren_Spill 

How's this work for you?

[Bren_Spill]

That worked perfectly, thanks David!

[reyreygg]

Spoiler